Avatar of Leo Torres
Leo TorresFlag for United States of America

asked on 

SQL Analysis Service

I just installed 2016 SSAS. I am trying to deploy my cube but I keep getting this error. In 2008 there was windows service you could stop and for Analysis service. I dont see that service with the 2016 version. I am running Windows 2012. Any advice on how and where I start this service?

Severity	Code	Description	Project	File	Line
Error		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.			0

Open in new window

SSASMicrosoft SQL Server

Avatar of undefined
Last Comment
Arifhusen Ansari
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

If you wan to see the 2016 services you have to open the Configuration Manger for 2016.

If you open 2008 service configuration manager, it won't display the others.

You can also directly start or stop the service using "Services" application.

User generated image
Now to solve the deployment issue. User actual instance name rather than local host.
Avatar of Leo Torres
Leo Torres
Flag of United States of America image


Yes I understand yes I looked at the services and Config manager but I dont see a SSAS Services. Now yes there are services down because I am in the process of uninstalling all of SQL 2016. So I can start all over again. Which bring me to another question is there a wizard to remove all these components or I have to go 1 by 1.
User generated image
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo