I’ve had some questions from people using the AdventureWorks tutorials on Analysis Services 2012, so I thought I would answer them here.
When deploying the Analysis Services project for the first time, you might get the following error message:
‘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.’
The first thing to check is that the login has access to the data source. Also, check that you’ve put in the full server\instance name if required: if you’re not sure how to check, open up SSMS and see if you can connect that way, and the full path will be in the login box.
If you’ve checked this, then it is worthwhile just checking that your Analysis Services service is actually started. This is simple: Go to Control Panel -> Administrative Tools -> Services and look for your Analysis Services service. If you don’t know which service to look for, try ‘SQL Server Analysis Services (MSSQLSERVER)’ and see if it is started.
Once you try to deploy the cube, you might get an error message about an Impersonation issue. If this is the case, then you will need to look at the Impersonation information that you’ve used in the data source. To do this, double-click on the data source, and choose the ‘Impersonation Information’. As per the tutorial, the setting says to use the option ‘Use the service account’
I hope that this answers some questions I’ve received – good luck, and please feel free to get in touch if anything isn’t clear.