RE: Analysis Services - Cannot connect to repository



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
.



Relevant Pages

  • Re: Relational to DW.?
    ... Analysis Services for some time. ... data on the same server. ... > interesting question......I assume your 'relational database' is for a ... > just finished it but have not put the pointer to it on my web site ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: problem with a DTS "Analysis Services Processing Task"
    ... Server A from Server B, then this is not the issue. ... database that you are trying to process. ... Where is your Olap Repository located? ... If it is in the default MS Access based repository, your SQLOper user ...
    (microsoft.public.sqlserver.olap)
  • Re: problem with a DTS "Analysis Services Processing Task"
    ... "Darren Gosbell" wrote: ... Server A from Server B, then this is not the issue. ... database that you are trying to process. ... Where is your Olap Repository located? ...
    (microsoft.public.sqlserver.olap)
  • Re: Copy database from development PC to deplyment server
    ... Release Management in the Analysis Services ... > to the sample database in my LAN. ... > developing/testing it, I'd like to copy it to the deplyment server, where ... > the data source. ...
    (microsoft.public.sqlserver.olap)
  • Re: problem with a DTS "Analysis Services Processing Task"
    ... Where is your Olap Repository located? ... If you repository is in a SQL database (especially if that database is ... not stored on Server "B"), check that the SQLOper user has access to ... Administrators" privilege. ...
    (microsoft.public.sqlserver.olap)