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.
