CRM 2011 installation error – SQL Server: The instance name must be the same as computer name

I got this error on a recent CRM Install.

The reason for this error was because the name of the SQL Server machine had been changed after SQL Server 2012 had been installed.

So what I think basically happens when you install CRM it creates the default instance with the same name as the computer – server name.

So I believe the CRM 2011 installation was looking for the service name which is the same name as the server and couldn’t find one.

luckily there is a couple of good blogs written on this

The answer to this problem is to rename the instance name with some SQL commands I never come across before.

Open up an SQL Query window and type


This will give you the name of the current server instance and a bunch of other values (but don’t worry about those)

We now need to drop this name by running the SQL command below, You put the value of the incorrect server name in the quotes  (where I have INCORRECT SERVER NAME”


now run the command below and the name in the quotes is the name of the server, don’t forget to add the comma local at the end otherwise the sql statement will error.


After you have done the change you can run


It should return the changed value.

You now need to run restart SQL Server and try the CRM install verification again

8 thoughts on “CRM 2011 installation error – SQL Server: The instance name must be the same as computer name

  1. johnthepro October 19, 2012 / 3:41 pm


    Any luck getting CRM 2011 to work with SQL 2012 AlwaysOn AG??? I’m looking for some extra info about config, but I keep getting stonewalled.

    John J.


  2. Hosk October 19, 2012 / 3:59 pm

    What does always on AG mean?

    I installed CRM 2011 on SQL Server 2012, there were a few problems with the reporting server and I had to change the account that Reporting server was running from Network service to local admin or network local.


    • johnthepro October 19, 2012 / 4:00 pm

      AlwaysOn Availability Groups – A new “database mirroring on steroids” feature of SQL 2012.


      • unshaikh March 4, 2013 / 3:20 pm

        Any luck getting CRM 2011 and SQL Server AG working? I am getting the above error


    • unshaikh March 5, 2013 / 7:16 pm

      I did follow that article, I got changed the connectionstring in MSCRM databases and changed the configdb registry key too. On the Crm server, I went into deployment manager, that is where the SQL Server field was pointing at the old server. Here is where the problem is. If I point it to SQL cluster name or to the Availability Group Listener name, it says instance name and computer name must be same. unless I point it to one of the nodes on the cluster, it keeps giving that error.

      So, I guess if you can help me out here with what you entered in deployment manager for your CRM organization and got things working, it would be great. The reason I think entering a cluster node’s name is wrong is because if the server fails, there will be no ‘automatic’ failover. I will have to go in and change things manually..

      Again, appreciate your help!


      • Hosk July 25, 2016 / 8:02 am

        I did the steps in the blog post and that worked for me


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s