Server Name changed, issues to connect to the SQL Server.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 24, 2010 at 8:59 am

  #231595

  In one of the Servers, I have SQL Server 2005/2008 default instance is installed. Windows Team had a request to change the name of the server (physical). Certainly, there would be issues to login to SQL Server, since it can’t able to identify name (name resolution issue).

  Please suggest me the steps (being DBA), how to overcome the issue!!

  Thanks.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  November 24, 2010 at 4:57 pm

  #1255396

  If Server Name changed

  from Server B to ServerA.

  To reflect the name change inside the SQL Server

  instance, you need to run the script below:

  1. EXEC sp_dropserver ‘ServerB’, ‘droplogins’;

  2. EXEC sp_addserver ‘ServerA’, ‘local’;

  3. Restart the instance.

  Best Regards,

  SQLBuddy