SQL Server Performance Forum – Threads Archive
Changing machine name
We are planning to move our SQL-Server in production to a new server. The Network group want to change the machine name at the same time but IP address will remain the same. What are the impacts? I know that Jobs inheritent the machine name when relocate the SQL-Server. Is anything else affected by changing machine name? CanadaDBAmake sure you run (in master), sp_dropserver OLDNAME followed by sp_addserver NEWNAME, LOCAL
And also you need to update sysjobs to set the ORIGINATING_SERVER name to be the new one where it is the old one. (need to allow ad-hoc updates to system catalogs first if it’s not already enabled.. and switch it off after. that’s pretty much it, I think (in SQL Server 2000) Tom Pullen
DBA, Oxfam GB
… and also refer to the client machines to affect the new servername on their client network utility. [8D] Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Update sysjobs to set the ORIGINATING_SERVER name? How? I thought sp_dropserver and sp_addserver do this but it seems not.
quote:Originally posted by thomas
make sure you run (in master),
sp_dropserver OLDNAME
followed by
sp_addserver NEWNAME, LOCAL
And also you need to update sysjobs to set the ORIGINATING_SERVER name to be the new one where it is the old one. (need to allow ad-hoc updates to system catalogs first if it’s not already enabled.. and switch it off after. that’s pretty much it, I think (in SQL Server 2000) Tom Pullen
DBA, Oxfam GB
And also you need to update sysjobs to set the ORIGINATING_SERVER name to be the new one where it is the old one. (need to allow ad-hoc updates to system catalogs first if it’s not already enabled.. and switch it off after. that’s pretty much it, I think (in SQL Server 2000) Tom Pullen
DBA, Oxfam GB
CanadaDBA
Client machines are using ODBC connection and I believe they use IP address to connect. Is it where and what I should take care or something else?
quote:Originally posted by satya
… and also refer to the client machines to affect the new servername on their client network utility. [8D]
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
CanadaDBA
quote:Originally posted by FarhadR
Update sysjobs to set the ORIGINATING_SERVER name? How? I thought sp_dropserver and sp_addserver do this but it seems not.
CanadaDBA
–allow updates to system catalogs
exec sp_configure ‘allow updates’, 1
reconfigure with override
–update sysjobs
update sysjobs set orginating_server = ‘NEWNAME’
where originating_server = ‘OLDNAME’
–disallow updates to system catalogs
exec sp_configure ‘allow updates’, 0
reconfigure with override like that Tom Pullen
DBA, Oxfam GB
]]>