Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

renaming and sql server (instance)

Posted on 2011-09-09
2
Medium Priority
?
356 Views
Last Modified: 2012-05-12
I needed to create a test environment for my main business application (McKesson) on server 2008 R2 and SQL2008.
I used Symantec system recover 2010 and imaged to a new similar server.  This went well and both are basically identical.  I change the ip address of the new server but cannot bring it on the network until I do a name change.
My problem is the SQL, I do not think it is a good idea to have two servers with the same SQL server name (the original is the same as the server name).
Is there a way to rename the SQL server so it is never confused with the original on the network?
0
Comment
Question by:wlasner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 2000 total points
ID: 36514043
Use:

EXEC sp_dropserver 'oldname'
GO
EXEC sp_addserver 'newname', 'local'
GO

Then, stop and restart SQL Server service.  check to see if the name was changed with SELECT @@servername
0
 

Author Closing Comment

by:wlasner
ID: 36523329
Executed against Master DB - worked perfect.

Thank you
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

670 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