locked
instance name must be the same as computer name RRS feed

Answers

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 AM
    Moderator
  • 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
  • Run sp_helperserver in either Query Analyzer (SQL 2000) or SQL Management Studio (SQL 2005)

    Sunday, August 26, 2007 5:25 PM
    Moderator
  •  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