SQL Server Performance Forum – Threads Archive
Instance renameIf I have a default SQL server named instance, can i rename this? Is it possible? If yes, what are the steps to do this?
http://msdn2.microsoft.com/en-us/library/ms143799.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by california6</i><br /><br />If I have a default SQL server named instance, can i rename this? Is it possible? If yes, what are the steps to do this?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Default instance can’t be named instance…<br />If you installed without instance name means when you run SELECT @@SERVERNAME, if the out put has the ” (ex: ServernameInstancename) in it… it is called named instance other wise it is defaul instance(ex<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />ervername) …<br /><br />When you rename the Server (Machine) name in computer management, your default instance will change to new server/machine name but you have to run the SP_DROPSERVER AND SP_ADDSERVER…and named instance will change to (new server/machine nameinstancename)…<br /><br />Note: You can’t change the instance name in sql server at all…<br />If your instance name is TestInst1 you can’t change it to TestInst2….<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided â€œAS ISâ€ with no warranties for accuracy.<br />