Sign in

Microsoft.com

Microsoft

Remove From My Forums

instance name must be the same as computer name

Question
0

Sign in to vote

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:

http://groups.google.com/group/microsoft.public.crm/tree/browse_frm/month/2006-01/550cb57b238fd934?rnum=71&_done=%2Fgroup%2Fmicrosoft.public.crm%2Fbrowse_frm%2Fmonth%2F2006-01%3F#doc_9ee03444fdecd7fe

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

0

Sign in to vote

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 AM

Moderator

All replies

0

Sign in to vote

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 AM

Moderator
0

Sign in to vote

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
GO

Friday, August 24, 2007 7:28 PM
0

Sign in to vote

Run sp_helperserver in either Query Analyzer (SQL 2000) or SQL Management Studio (SQL 2005)

Sunday, August 26, 2007 5:25 PM

Moderator
0

Sign in to vote

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