Dynamics 365 – “The instance name must be the same as computer name”

When installing Dynamics CRM on a server you may find you receive an error stating “The instance name must be the same as computer name”. This error refers to the SQL database which contains an invalid name for the server.

This normally only occurs when a machine has been renamed since SQL was installed however I’m sure there are numerous ways to cause this. It can easily be fixed however.


SQLName3

Fixing the Problem

To fix this issue you will need access to the SQL database.

  1. Open SQL Server Management Studio then connect to the database.
  2. Select ‘New Query’ in the ribbon.SQLName1
  3. (optional) Enter select @@servername and then click Execute to return the currently stored server name.SQLName2
  4. Find the current computer name, if not known this can easily be found by accessing File Explorer then right clicking ‘This PC’ in the left-navigation then ‘Properties’ which will show the Computer Name in the window that opens.
  5. In SQL Server Manager enter SP_DROPSERVER “WrongName” then click Execute. This will drop the reference to the wrong machine name.
  6. Now enter SP_ADDSERVER “*RightName*”, local which will change the database engine entry for the name of the computer to the correct name.

Once done you should be able to either restart the CRM installer or simply press back then continue and it will re-check the requirements and allow you to progress.


Further Information

More information on these commands may be found at the following links –

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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