Dynamics CRM Problem

[Homer-Simpson]

We are currently trying to install a new version of Dynamics CRM on a new server. We are pointing it to a database on another server (SQL 2005/Server 2008 R2). When it does its first set of checks it comes back with the error

"The instance name must be the same as computer name"

Now from a quick google it looks like if you installed the SQL server, then renamed it, it can cause this problem. I have ran both the commands below

sp_helpserver

SELECT @@SERVERNAME AS 'Server Name'

Both are showing the correct computer name. To me it sounds like this isn't the issue. We would have renamed the server BEFORE installing SQL (it is an early step in our server deployment checklist).

Anyone else got any ideas? The port is open and I can query the machine fine from SQL Management Studio. We are running on a non standard SQL port and the SQL Browser service is disabled, could this be the issue?

 

[sparkymark75]

Something similar only slightly different at http://blogs.msdn.com/b/emeadcrmsup...e-must-be-the-same-as-computer-name-quot.aspx

Make sure to restart SQL services.

 

[Homer-Simpson]

Something similar only slightly different at http://blogs.msdn.com/b/emeadcrmsup...e-must-be-the-same-as-computer-name-quot.aspx

Make sure to restart SQL services.

That was the info I was talking about in the first post, it wasn't this in the end.

I had to create a string under


[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo]

The string name was the original servers name (where the DB is) with the value data of DBMSSOCN,servername\instancename,port

I then entered the string name in the connection box and it is working! It looks like you can't specify the SQL port of a named instance during the installation.