olap-cubesql-server-2012-expresssqlbrowser

A connection cannot be made. Ensure that the server is running


When I am trying to process dimensions after creating a data source view I get the error:

The project could not be deployed to the server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties,click on the Deployment tab, and then enter the name of the server.

I have checked in task manager & SQLBrowser is running. Why am I getting this error?


Solution

  • I was able to get the SQL Server instances on my computer this way:

    1. Start Menu
    2. Microsoft SQL Server 2008 or your version
    3. Server Installation Center
    4. Admin login
    5. Select "Tools" from left menu
    6. Select "Installed SQL Server features discovery report"

    You then get a nice HTML web page. You want to look for Database Services. You should see an instance name. Mine is called "SQLEXPRESS." So the combination of server name and instance would be MYCOMPUTER\SQLEXPRESS given that my computer name is MYCOMPUTER.

    BTW, the default instance name is MSSQLSERVER.

    Alternatively, you can get it from your registry. Just run regedit and look for this key: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL