SQL Server 2008 Analysis Services Deployment Connectivity problem

Posted on 2012-09-17
Last Modified: 2016-02-18
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!
Question by:daldenwilliams
    LVL 37

    Accepted Solution

    MSSQLSERVER is the default instance, you don't need to mention it.  So when you connect to WIN-3VTVH3GMKVH, you're actually connecting to WIN-3VTVH3GMKVH\MSSQLSERVER.

    Author Closing Comment

    Thanks, Valentino.  This is exactly the type of silly question I have the most trouble solving on my own:  so fundamental that no one else would make the mistake and have to ask about it.  The complex problems are often easier to research.
    LVL 37

    Expert Comment

    Glad I could help :)

    I have to say though that what you were trying to do is normal.  It is actually illogical that it refuses to connect while specifying the name of the default instance.  Even though it's the default, it shouldn't mean that you can't specify it, right? Oh well, I guess that's one of the "features" we'll have to live with...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now