RE: Analysis Services - Cannot connect to repository
- From: "Diane" <Diane@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 15:14:02 -0700
I edited the repository connection string & removed the Initial Catalog which
referred to that database, BUT now I get the following error when trying to
connect:
Invalid object name "OlapObjects"
????
"Diane" wrote:
> This has a bit to do with Project server - but I think you guys can help me.
> I was trying to install conffigure Project Server - to no avail. One of the
> steps of the install is to migrate the repository for SQL Server to one named
> Analysis Services Repository. Anyway. After failing the Project Server
> install. I decided to start fresh - removed Analysis Services, SQL & Project
> Server (and the Analysis Services Repository"
>
> I re-installed SQL Server. Put on SP3a. I re-installed Analysis Server.
> SP3a.
>
> Now, when trying to test the connectivity of Analysis Services by clicking
> on the Server name, I get the following message:
>
> Cannot connect to the repository.
>
> Analysis Server: SERVERNAME
>
> Error:
> Cannot open database requested in login. "Anlysis Services Repository".
> Login failed.
>
> Where is this database name set-up??? I just want it to go back to the
> default database name that comes vanilla out of the box?? Please help - this
> is turning into a disaster for me.
>
> Thank you.
> Regards,
> Diane
.
- References:
- Analysis Services - Cannot connect to repository
- From: Diane
- Analysis Services - Cannot connect to repository
- Prev by Date: Re: SP4 Installation Problem on Win2000/SQL Enterprise Edit.
- Next by Date: SQL 2000 coexist with SQL 2005 on same machine
- Previous by thread: Analysis Services - Cannot connect to repository
- Next by thread: SQL 2000 coexist with SQL 2005 on same machine
- Index(es):
Relevant Pages
|