SQL Server 2008 Analysis Services Deployment Connectivity problem
Posted on 2012-09-17
I've created my first Cube based on the ContosoRetailDW. Builds fine. When I try to Deploy it I get "Error 4 The project could not be deployed to the 'WIN-3VTVH3GMKVH\MSSQLSERVER' server because of the following connectivity problems : The 'MSSQLSERVER' instance was not found on the 'WIN-3VTVH3GMKVH' server..."
I'm running SQL Server 2008 R2 on Windows 2008 with all the latest updates. All servers are within a single VMware machine in my lab environment (except for the DC on a separate VMware machine).
I've tried everything I could understand from a Google search including:
- verifying that the instance of SQL Server Analysis Services and SQL Server Browser are Started
- trying different variations of the Target Server Property for my SSAS Project.
When I try to connect to the WIN-3VTVH3GMKVH\MSSQLSERVER instance of Analysis Services using Mgt Studio it only gives me the option to connect to WIN-3VTVH3GMKVH which surprises me. Seems like I should see the MSSQLSERVER instance.
I need some help unraveling this. Thanks!