SQL Server naming issue

• Eshika

  SSCrazy

  Points: 2046

  More actions

  January 21, 2011 at 3:18 pm

  #230709

  Hello All,

  I am trying to rename the sql server name; when i tried to use the

  select @@SERVERNAME

  sp_dropserver 'abc'

  sp_addserver 'SQL' ,Local

  I restarted the server, ran -select @@SERVERNAME resulted as SQL.

  But, when I connect - after the server icon it states "abc(SQL server version number- login)"

  Please suggest, I want to see it as "SQL(SQL server version number- login)"

  Server name where the SQL server is installed is abc.

  Thanks,

  Swetha K

• Eshika

  SSCrazy

  Points: 2046

  More actions

  January 21, 2011 at 3:35 pm

  #1276838

  Got the answer - As is is default instance - sql server inherits the computer name.

  Thanks