How can I rename a SQL Server 2008 instance without reinstalling?
For example, if the db is referenced as "MySQLServer\MSSQL2008", how can I rename to "MySQLServer\SQL2008"?
Sql-server – How to rename a SQL Server 2008 instance
sql serversql-server-2008
Best Answer
I don't think it is possible to rename without installing.
There are traces left to the name in a few internal databases such as replication and you may find errors later on.
If you can, unless you have more than one instance, you are best off reinstalling and then importing all your databases again.