Thursday, February 16, 2012

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

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.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.

No comments:

Post a Comment