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"?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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.
I know that this script is ubiquitous across the ‘net, but whenever I google for it I come up with elaborate stored proc’s that are overkill for my needs – so here are the commands necessary to rename a SQL Server instance, for posterity:
EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘
EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’
And a few notes relating to their usage:
I would also recommend the following when renaming a SQL Server:
If you are performing this task as part of a machine rename, rename the machine first then rename the SQL Server. Once you have renamed the SQL Server, do a full restart of SQLServer, including any dependent service.
I got this information from the link below:
This blog seems to indicate it's quite easy.
You'd want to use ALTER DATABASE.
In this situation, for your example above, I'd try:
ALTER DATABASE MSSQL2008 MODIFY NAME = 'SQL2008'