The instance name must be the same as computer name.

when you changed the Computer Name when there is already a SQL Server 2005 instance running (exists) in your system, then you may have to face “The instance name must be the same as computer name” at the time of installing the Microsoft CRM 4.0 Server.

As the solution you have to make sure the exact name of the SQL Server instance running in your computer. for that execute the following command in Query Analyzer :

select @@Servername

if the above commands gives you the output as the old server name

Then execute the following command:

sp_dropserver ‘old_sql_server_instance_name’, ‘droplogins’
GO
sp_addserver ‘new_sql_server_instance_name’, ‘local’
GO

Advertisements

One Comment to “The instance name must be the same as computer name.”

  1. hi, my sql instance name and computer name are same. but i still get the error…help me…

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

%d bloggers like this: