changing instance name

• geetha@in

  Ten Centuries

  Points: 1175

  More actions

  January 4, 2011 at 12:43 am

  #244835

  Hi,

  can i change the named instance name in sqlserver r2...if yes how can i change..

  Thanks

  Rekha

• Johan Bijnens

  SSC Guru

  Points: 135376

  More actions

  January 4, 2011 at 1:05 am

  #1268795

  AFAIK you cannot rename a named instance.

  Best is to just install an instance with the new name and port everything from your wrongly named instance to the new one.

  After that process just uninstall the current instance.

  ref: http://technet.microsoft.com/en-us/library/ms143799.aspx

  and

  http://msdn.microsoft.com/en-us/library/ms178083.aspx

  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

• appalaraju_k-596051

  Old Hand

  Points: 383

  More actions

  January 4, 2011 at 2:08 am

  #1268811

  Thanks for reply