July 24, 2003 at 4:54 am
I am trying to change the NT Server Name
To a diffrent name .
When restart the server I am getting a message on the NT Log a bout SQL Installation Corrupt.
Can I Change The server name with out Corrpting the SQL Installation
Can somthing be done a bout it
July 24, 2003 at 5:52 am
Hi,
Which version of SQL have you got installed? If it's 7 then in my experience you can't rename the server without having to reinstall SQL afterwards. If you have SQL 2000 then it is possible. Although you would have run
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
Hope this helps.
Laters
*I didn't do anything it just got complicated*
"I didn't do anything it just got complicated" - M Edwards
July 24, 2003 at 8:43 am
You can rename in SQL 7.0. Just run the setup again, it won’t install the software but it will change the required files to recognize the new server name. Drop and add the server name. In SQL 2000 I agree with Ritch
Shas3
July 24, 2003 at 8:45 am
I have Found an article about it
http://www.sqlservercntral.com/columnists/bknight/renameserver.asp
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply