[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

renaming and sql server (instance)

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
wlasner
Asked:
wlasner
1 Solution
 
Chris MangusDatabase AdministratorCommented:
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
 
wlasnerDirector, ITAuthor Commented:
Executed against Master DB - worked perfect.

Thank you
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now