Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
Posted - 06/04/2008 : 15:51:51
| I am installing SQL Server 2005 on a couple of servers where the windows server will later be renamed. One is a default instance, and one is a named instance.
Does anyone have a procedure for this, or know any gotchas for 2005? I have done this for SQL 2000 many times, but never of 2005.
Books Online seems to say you just rename the server, and everything will be OK.
I know how to rename the server internally with sp_dropserver and sp_dropserver. It looks like you no longer have to update originating_server in msdb.dbo.sysjobs, because it was replaced by originating_server_id.
No nubeez! Xpurts ownli pleez!!
CODO ERGO SUM
Edited by - Michael Valentine Jones on 06/04/2008 16:21:13