Changing The Server Name An IP address

[Peter]

I have SQL ver 7.0 running on NT ver 4.0 sp5

I had to change the name of the server from server1 to server2
now I am Getting a message

"Your SQL server installation is either corrupt or has been tampered with (Unknown package id). Please rerun setup"

is there any other way besides rerunning setup ?

Thanks in Advance ??

Peter

[SAN_Russia]

THE other way is rename your server back to previose name.
Don't run setup you will lose your databases !

P.S. There is no logic to disallow the renaming -
its small new bug-present from MICROSOFT .

No Thanks at all

Alexander

[Ray Miao]

Just run sql setup once again, then run 'sp_dropserver old_name' and 'sp_addserver new_name' in query analyzer. This is the way for sql7.


------------
Peter at 11/2/99 2:28:08 AM

I have SQL ver 7.0 running on NT ver 4.0 sp5

I had to change the name of the server from server1 to server2
now I am Getting a message

"Your SQL server installation is either corrupt or has been tampered with (Unknown package id). Please rerun setup"

is there any other way besides rerunning setup ?

Thanks in Advance ??

Peter