Change in name of Default instance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Change in name of Default instance

Hi I have to, for some reason change the name of the server on which SQL default instance is installed. What will be the impact of this name change on the default instance? What changes need to be done on the SQL side? Regards
Riya
Hi,<br />please refer below links if it helps :<br /><br /><a href=’http://support.microsoft.com/kb/260414/en-us’ target=’_blank’ title=’http://support.microsoft.com/kb/260414/en-us'<a target="_blank" href=http://support.microsoft.com/kb/260414/en-us>http://support.microsoft.com/kb/260414/en-us</a></a><br /><br /><a href=’http://www.lazydba.com/sql/1__1691.html’ target=’_blank’ title=’http://www.lazydba.com/sql/1__1691.html'<a target="_blank" href=http://www.lazydba.com/sql/1__1691.html>http://www.lazydba.com/sql/1__1691.html</a></a><br /><br /><a href=’http://myitforum.techtarget.com/articles/18/view.asp?id=4983′ target=’_blank’ title=’http://myitforum.techtarget.com/articles/18/view.asp?id=4983′<a target="_blank" href=http://myitforum.techtarget.com/articles/18/view.asp?id=4983>http://myitforum.techtarget.com/articles/18/view.asp?id=4983</a></a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />HTH<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Valid references by Hemant and make sure you test all the points mentioned in the articles. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Riya, Can you list the steps how you did this activity? Just curious about this activity. Thanks and Regards
-Johnson

Hi, I was successful in changing the name of default instance.
1. Renamed the server
2. sp_dropserver ‘old servername’
3. sp_addserver ‘new servername’
4. Reboot the machine
5. Now register the default instance with the new servername. I was able to get back all the databases in its original state. But the only problem I faced was while executing select @@servername. It showed me "NULL" instaead of the new server name.
Regards
Riya Riya
it is bughttp://support.microsoft.com/kb/303774
—————————————-
http://spaces.msn.com/members/dineshasanka

]]>