Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-02-04 : 14:15:10
|
| 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?Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-04 : 15:03:53
|
| Besides the jobs, you just need to make sure to run sp_dropserver and sp_addserver. Of course if you have any scripts, DTS packages, or anything else with the old server name, then those would need to be changed as well.Tara |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-04 : 15:18:52
|
Thanks Tara,Running only the sp_dropserver and sp_addserver solves the machine name change problem? I think DTS packages and scripts or SPs are not using machine name. Do you have a link in this regards (Machine name change)? quote:
Originally posted by tduggan
Besides the jobs, you just need to make sure to run sp_dropserver and sp_addserver. Of course if you have any scripts, DTS packages, or anything else with the old server name, then those would need to be changed as well.Tara
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-04 : 15:21:06
|
| Q1: Yes. Q2: No. You would have to manually check on all those and make changes where appropriate.Tara |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-07 : 09:12:37
|
| What about clients? Clients are using ODBC and IP server's IP address. Should I worry about it? Also, what about ORIGINATING_SERVER name?Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 12:31:07
|
| If the server's IP address is changing, then yes you'd have to hit the clients too. It can be done via a registry edit over a login script though. Not sure what you are referring to on the second question.Tara |
|
|
|
|
|
|
changing machine name