Rename a SQL Server instance, is it possible?
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 clustered. Also for SQL 2000 version specific information refer to AA197071 link on the MSDN. Further the links for SQL 2005 version and specific to Clustered installations too, http://msdn2.microsoft.com/en-us/library/ms143799.aspx on SQL2005 & http://msdn2.microsoft.com/en-us/library/ms178083.aspx for SQL 2005 Virtual server Cluster installations.
But say if you want to rename the instance that is already installed and used by the application then you have to reinstall with the name you wanted and move the databases, big job eh.
