Very Computer

Hi,

I am new to OLAP, but had to set up an SQL server with Analyis services.
Once we had it set up, I needed to change the machine name, since we
experienced other issues with an improper character in the computer name.
Anyway, since I have changed the name, I can no longer connect to the server
with the Analysis Manager. I had previously migrated the repository as
native format to the local SQL server's MSDB database. Now when I attempt to
connect, I receive the error message...

Cannot connect to repository

Analysis Server: <servername>

Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

Can you help me through this. I would very much appreciate any assistance
you might offer.

Thanks,

Steve Bering
Bluewater

Steve Bering
Bluewater

Quote:> Hi,

> I am new to OLAP, but had to set up an SQL server with Analyis services.
> Once we had it set up, I needed to change the machine name, since we
> experienced other issues with an improper character in the computer name.
> Anyway, since I have changed the name, I can no longer connect to the
server
> with the Analysis Manager. I had previously migrated the repository as
> native format to the local SQL server's MSDB database. Now when I attempt
to
> connect, I receive the error message...

> Cannot connect to repository

> Analysis Server: <servername>

> Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.

> Can you help me through this. I would very much appreciate any assistance
> you might offer.

> Thanks,

> Steve Bering
> Bluewater