Wednesday, March 21, 2012

How to connect Anasysis server in different domain

Please let me know the steps to connect Analysis server 2000 from different domain.

fyi for connecting sql server I am using SQL server authentication and I am able to connect.

try this, it works for me in as 2005:

create a local user on the AS server as yourself. Use the same user name/password that you have on the other domain.

example:

domain dom1:

you are logged on as dom1\bob with password xxxxx

On the AS server, create a local user bob with password xxxx. give bob access to the cubes.

Test your connection.

|||

this also works:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1365877&SiteID=1

|||

Thanks for you information,

It is working now.

No comments:

Post a Comment