Error browsing Analysis Services Tutorial cube

Hi. I have two instances of SQL Server installed. One is unnamed and refers to a SQL Server 2000 installation. The other one is named PEDRO\SQLDEV2005 and refers to a SQL Server 2005 installation. I was going through the MSAS tutorial and when I was trying to browse the cube the following error occurred:

The query could not be processed: o Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'PEDRO' server. o Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'PEDRO' server.

The problem is that my server name isn't PEDRO, but PEDRO\SQLDEV2005. Where do I change the server name?

Pedro Martins

Portugal

The error message is correct. You might be running several instances of Analysis Sever on your machine. But you have a single SQL Browserver service that serves them all.

Try and see if SQL Browser service is started. Do you have connectivity to the Domain controller? There is known issue with accessing named instace is case if domain controller is unavailable.

See if you can connect to Analysis Server using SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.