Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' 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 am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.