Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-07-23 : 11:45:24
|
| Hello ,I have a SQL 2000 with Analysis server installed on it . Its in a different domain . When i am trying to register the server remotely i.e from another domain ,from another server it gives me an error that : 'Cannot connect to the repository .Analysis Server : <Server_name>Error : Cannot open database requested in Login '<Database_name > Login fails . Do you wish to register this server ? ' Both the domains are trusted . Except that the OS where the Analysis server is running is Windows 2000 . I am trying to connect through SQL 2000 Server with Windows NT 4.0 Server . We have another Analysis server which is running but on Windows NT 4.0 OS where i can easily register that server . I tried providing access with all the rights to concerned domains , but in vain . I am exhausted trying to figure out the problem .Any assistance in this regard would be of great help to me .ThanksRavi . |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-23 : 15:01:18
|
| Can you add your user account to the OLAP Administrators local group on the server in the other domain ? This should allow you access.What are the various service packs involved ?HTHJasper Smith |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-07-24 : 03:27:03
|
| Hi ,I have already added my user account in the local OLAP administrators group , but still it does'nt work . Any ideas ?Thanks .Ravi. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-24 : 09:20:40
|
| On the 2000 server have you migrated the repository to SQL Server or is it still native format ? It should work across trusted domains - it definately is a 2 way trust ?HTHJasper Smith |
|
|
|
Bunmi
Starting Member
3 Posts |
Posted - 2002-08-08 : 10:29:58
|
| I'm having the same problem. I've migrated the repository to SQL Server and I am a member of the local Administrator and OLAP Admin groups. After migrating the repository to Meta SQL Server, I now get a new message that says "Path not found" when I try to register the server. Any ideas would be appreciated. |
|
|
|
|
|
|
Analysis Server registration . Pl. Help !!!