Wednesday, January 15, 2014

Configure SQL after change computer name

After changing the computer name for a machine that has a SQL installed there is some additional step required:
1- select @@servername 
     > to view the current server name
2- sp_dropserver "Old_Server_Name" 
     > to remove the old server name
3-  sp_addserver "New_Server_Name", local 
      > to add the new server name

No comments:

Post a Comment