Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error when connecting

Status
Not open for further replies.

ietprofessional

Programmer
Apr 1, 2004
267
US
I've had SQL Server 2000 running for a while and now I would like to start utilizing Analysis Services. I updated to the current Service packs, but I'm getting an error when I try to connect Analysis Services. Can someone help?
How do I fix this problem?

Errors occurred while connecting to (Server Name)
Cannot connect to the repository.

Analysis server: (Server Name)

Error:
Cannot open a database created with a previous version of your application.
Do you still want to register this server?

Thanks,
Harold
 
This is usually caused by lack of rights to the OLAPrepository$ share.

1) Make sure the user that your using to manage the Analysis Server is in the OLAP Administrators group

2) Make sure the OLAP Administrators group has Full Control right to the MSOLAPRepository$ share in both the Sharing and Security tabs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top