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.