Solved

Is it possible to rename a SQL Server instance?

Posted on 2014-01-27
2
522 Views
Last Modified: 2014-01-28
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!
0
Comment
Question by:data_bits
2 Comments
 
LVL 15

Accepted Solution

by:
pateljitu earned 250 total points
ID: 39813139
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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 39816738
After you do sp_addserver you will have to restart the SQL Sever instance.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question