SqlServer-QA.net

Can I rename an instance of SQL Server after I have already installed it on the computer?  Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by default when you change the name of the computer that is running SQL 2000 version, the ...

Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name changes yes, you can change the name of an instance as long as the server is not ...