Answered by:
instance name must be the same as computer name

Question
-
We have a SBS 2003 server & a W2k3 Standard server w/ SQL Server 2005.
I am attempting to install CRM 3.0 SBE on SBS with the databases and reporting services on the W2k3 server.
Before the final install can complete, I receive the following error under the SQL Server test:
The instance name must be the same as computer name
The Reporting services section completes successfully. I have been doing a done of digging and found this website:
I changed the server name on the SQL server before I joined it to the domain (The old hostname included a "-"). When I open the enterprise management, it shows the correct hostname.
Will the steps in the above link correct this problem? Are these actions safe? If not, what are the next steps?
Please help,
Keenan
Tuesday, July 31, 2007 3:05 AM
Answers
-
The resolution is to use the SQL stored procedures sp_addserver and sp_dropserver; for full instructions see
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
This is a standard operation when a SQL Server machine has been renamed after SQL was installed
Tuesday, July 31, 2007 7:26 AMModerator
All replies
-
The resolution is to use the SQL stored procedures sp_addserver and sp_dropserver; for full instructions see
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
This is a standard operation when a SQL Server machine has been renamed after SQL was installed
Tuesday, July 31, 2007 7:26 AMModerator -
I am having the same issue, but have an additional twist. I also am new to SQL, but have worked with MS server product for years.
The SQL server that I am trying to install CRM on is a virtual server that has been sysprep'd with a computer name that was auto generated.
I copied the virtual disk and created a new machine. I then renamed the machine and began my CRM install.
Is there a way to find out what the original auto-generated server name was, so that I can run
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GOFriday, August 24, 2007 7:28 PM -
Run sp_helperserver in either Query Analyzer (SQL 2000) or SQL Management Studio (SQL 2005)
Sunday, August 26, 2007 5:25 PMModerator -
DavidJennaway wrote: Run sp_helperserver in either Query Analyzer (SQL 2000) or SQL Management Studio (SQL 2005)
Some correction. No sp_helperserver, but sp_helpserver. Another method is run select @@servername
Thursday, May 29, 2008 2:35 PM