locked
Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified. RRS feed

  • Question

  • I get this error when trying to deploy a Analysis Services Project. I don't have the cube defined yet. I did have sql 2000 and sql 2005 installed on the same machine at one point, but I've since uninstalled them both and reinstalled only sql 2005.

     

    Error 1 Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '.' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '.' server. Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified. Errors in the metadata manager. An error occurred when loading the Tbl PM Project dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\Tbl PM Project.4.dim.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . Errors in the metadata manager. An error occurred when loading the MBN Gargle cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\MBN Gargle.15.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. .   0 0 

     

    The problem is actually because it is trying to access a named instance ".\sql2005", which no longer exists. I can see that from this message,

    • "Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified."

     

    This happens on brand new projects.

    I saw other threads on this subject and the resolutions didn't work. I tried installing the msi file listed on the sql server 2005 packages install (listed on another thread, sorry I don't have the file name handy) but it didn't work.

    How do I get around this bug and have SQL look at the only sql instance on the machine, the localhost? The browser service is turned on.

    Bob

    Monday, April 17, 2006 4:42 PM

Answers

  • Check your BI Dev studio project settings. Looks like your project is still trying to deploy to the .\sql2005 instance.

    Right click on your project node select "Properties". Click on the "Deployment" node on the left and see what is the value for the Server property. Change it to the "localhost".

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

    Tuesday, April 18, 2006 2:36 AM