can we change the instance name

• bharathkumar.pammiramesh

  SSC Rookie

  Points: 34

  More actions

  May 16, 2011 at 9:26 am

  #389538

  Is it possible to change the instance name in sql 2008 after installation.

  We gave the wrong instance name at the beginning, now we need to change without re-installation

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 16, 2011 at 11:01 am

  #1325303

  You will probably be better reinstalling as opposed to changing the instance name.

  http://stackoverflow.com/questions/907851/change-sql-server-instance-name

  http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/f7b1fae3-e5e1-4aa9-9285-68694e09a0a3

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/