Issue with Voyager connection to MS Analysis Services 2000

[Former Member]

I get the following message -

Login failed.Please check that your username and password are valid.

OS - Windows 2003 server sp2

BOXI R2 - sp4

MS Analysis Services - 8.0.2039

When I set up the Voyager connection

name - test

Provider - MS OLE DB Provider for OLAP Services 8.0 (only one in the drop down)

Server type - server

server - name of the server (bo2k3test)

authentication - prompt

I then put in a uid and pwd for a user that is part of the OLAP Administrators group

Any ideas?

thanks

[I_MCA · Accepted solution]

The username needs to be fully qualified, ie DOMAIN\Username.

So if the username is "Anne" and this is a local account on the MSAS server then you enter ".\Anne" (without the quotes).

Regards

[Former Member · Accepted solution]

Awesome - That worked.

Thanks for the quick turnaround.