Is it possible to rename a SQL Server instance?

Is it possible to rename a SQL Server instance?

We cloned a dev server to create a new production server. Even though the name of the computer is different, when I bring up SQL Server management Studio, it shows the name of the source dev environment.

Is there a way to change it to new name to match the functionality?  Or do we need to uninstall sql server and reinstall it all? I'm under a big time crunch so if i can rename it, I want to try that first.

Its sql server 2012.

Thanks!
data_bitsdbaAsked:
Who is Participating?
 
pateljituConnect With a Mentor Commented:
You can rename existing instance

sp_dropserver <old_name>;
GO
sp_addserver <new_name>, local;
GO

-- execute this query to verify name change
SELECT @@SERVERNAME

Open in new window



Article:
http://technet.microsoft.com/en-us/library/ms143799.aspx

http://www.sqltechnet.com/2012/09/how-to-rename-sql-server-instance.html
0
 
Anthony PerkinsConnect With a Mentor Commented:
After you do sp_addserver you will have to restart the SQL Sever instance.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.