SQL Server 2019 Instance Name Change

• rmsdip69

  SSC Enthusiast

  Points: 173

  More actions

  March 15, 2022 at 5:04 pm

  #4000048

  I am running SQL 2019 on Windows 2019 server and have come across an issue I have not seen before and cannot find a resolution on the web. I have went through the normal process of changing the Instance name by using the following..

  EXEC sp_dropserver '<old_name\instancename>';

  GO

  EXEC sp_addserver '<new_name\instancename>', local;

  GO

  I rebooted the server afterward but I have to use the original instance name to actually connect but if I run

  Select @@servername it returns the new instance name.. It acts like Windows Server 2019 is blocking the final piece the name change. Anybody seen this and have a fix?

  Thanks

  Rich

• rmsdip69

  SSC Enthusiast

  Points: 173

  More actions

  March 16, 2022 at 1:02 pm

  #4000539

  I found my answer on this. Thanks

• Jeff Moden

  SSC Guru

  Points: 1004621

  More actions

  March 16, 2022 at 4:18 pm

  #4000671

  rmsdip69 wrote:

  I found my answer on this. Thanks

  Would you mind sharing what you found to be the answer, please?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Johan Bijnens

  SSC Guru

  Points: 135538

  More actions

  March 17, 2022 at 7:19 am

  #4001107

  Posting your solution would be very much appreciated.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me