Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Renaming a SQL 2K Server? Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2008 1:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 1:41 PM
Points: 31, Visits: 68
Just a quick question...

I have a SLQ 2K server on W2K. 55 databses. Would renaming the server name in Windows
affect the databases? Would I need to re-register the new name in SQL?

Post #457591
Posted Tuesday, February 19, 2008 1:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:16 AM
Points: 1,157, Visits: 3,263
After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.

use master
go
exec sp_dropserver 'old server name'
go
sp_addserver 'new server name', 'local'
go



Tommy

Post #457599
Posted Tuesday, February 19, 2008 1:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 1:41 PM
Points: 31, Visits: 68
Yes. I did find this in the forums.

Thx.
Post #457602
Posted Tuesday, February 19, 2008 2:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 1:41 PM
Points: 31, Visits: 68
Actually, one more quest...I had to rebuild the server a few weeks ago on a new box.
The new server was built on a node name caled sqltest. After I moved the databases from the old server to the new server, I renamed the node name in Windows (on new server) back to sqlproduction. Do I need to run that query in SQL?

Thanks
Post #457672
Posted Tuesday, February 19, 2008 3:05 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:16 AM
Points: 1,157, Visits: 3,263
A simple verification - on the server in question, execute a

select @@servername

If this returns the correct server name then you are all done. If not use the sp_dropserver, sp_addserver method to change the name.



Tommy

Post #457681
Posted Tuesday, February 19, 2008 6:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 6, 2014 2:38 AM
Points: 398, Visits: 2,423
Tommy Bollhofer (2/19/2008)
After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.

use master
go
exec sp_dropserver 'old server name'
go
sp_addserver 'new server name', 'local'
go



Just be aware that your current jobs may not function because of changing the server's name you can verify it with this query

SELECT *
FROM msdb..sysjobs


"-=Still Learning=-"

Lester Policarpio

Post #457739
Posted Tuesday, February 19, 2008 6:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 1:41 PM
Points: 31, Visits: 68
All good, query returned the correct node name.

Now I have an .idc error. When in the app that connects to the sql database, there is a link to IE that users click on to open IE.

The error is: 'unable to open http://servername/idi/scripts/distsumsetdirect.idc? Cannot download the information you requested'
Post #457745
Posted Tuesday, February 19, 2008 8:28 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
You talked about node. Did you build your SQL Server on a cluster? A node is different from a name of an SQL Server on a cluster.
Post #457782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse