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

mnv picture mnv · Oct 23, 2017 · Viewed 11.5k times · Source

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?

Answer

Charles Owen picture Charles Owen · Oct 23, 2017

Check that the SQL Server service itself (or MSSQLSERVER) is running. Also check the connection string.

If you want to deploy the project to a named instance of Analysis Services on the local computer, or to an instance on a remote server, change the Server property to the appropriate instance name, such as \.

https://docs.microsoft.com/en-us/sql/analysis-services/lesson-2-5-deploying-an-analysis-services-project

You need the server name and the instance name.