February 27, 2002 at 2:38 pm
We ae upgrading our SQl 7.0 box. We want to rename the current server and copy our databases to a new box with the original name. However, the new box will have a different IP address. Will we have to reconfigure the ODBC settings on our clients
when this process is complete?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
February 27, 2002 at 2:44 pm
If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.
Steve Jones
February 27, 2002 at 2:44 pm
If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.
Steve Jones
February 27, 2002 at 3:15 pm
We use DNS, so I hope we are home free.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
February 27, 2002 at 4:33 pm
Should be. The only thing that is bound to the old box is the sid, so if you had some service that relied on an ACL, you might have issues. SQL is at the application layer, so as long as the name resolves, and the login credentials are there, you are ok.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply