Server Migration

External Since: Feb 29, 2008 Posts: 7

Using SQL 2000 If I move from one servername to a new servername is their a
way to point the old servername to the new servername without changing all
the ODBC Connections, Ive tried DNS Entries and that does not work.

External Since: Dec 12, 2008 Posts: 9

On Dec 11, 2:02 pm, Marc wrote:
> Using SQL 2000 If I move from one servername to a new servername is their a
> way to point the old servername to the new servername without changing all
> the ODBC Connections, Ive tried DNS Entries and that does not work.

did you run the sp_changeservername or something like that when you
renamed the server?