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.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Analysis Server Registration Problem

Author  Topic  Bunmi Starting Member 3 Posts Posted - 2002-12-03 : 13:47:06 I have a SQL 2000 with Analysis server installed on it . When i try to register the server remotely i.e 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 ? ' I then migrated the repository to SQL Server and made sure that 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/help would be appreciated. Thanks.