Â*Â*Â*¿ sp_ReName_SQLsvr ?

[Jeff Proctor]

Is there a process to rename the server?

It appears that @home requires me to use change my computer name. I am currently using a static IP, however remote access VNC, PCAynwhere are not working, including in-consistant ping results.

I would like to rename the MSSQL server, without having to face the msg that MSSQL is missing or corrupt.

Much grats for any assistance.

jEfFp...

[Gary]

Jeff

You have not said which version of SQL Server you are using.

In SQL 6.5 it's easy (sp_dropserver, sp_addserver)

In SQL 7.0 you have to change the name of the server then run SETUP then run sp_dropserver, sp_addserver

See BOL for description of stored procs.

Gary


------------
Jeff Proctor at 8/10/01 1:30:12 AM


Is there a process to rename the server?

It appears that @home requires me to use change my computer name. I am currently using a static IP, however remote access VNC, PCAynwhere are not working, including in-consistant ping results.

I would like to rename the MSSQL server, without having to face the msg that MSSQL is missing or corrupt.

Much grats for any assistance.

jEfFp...

[Patrick]

This question is not involving only your SqlServer component.
Several systems softwares like WINS or DNS are in the lan/wan arena to solve the servers name relationships with the IP addresses. (I voluntary forgot the Hosts files)
This kind of maintenance is more in the network or NT teams area.
Ask them to investigate on this trouble.
Cheers


------------
Jeff Proctor at 8/10/01 1:30:12 AM


Is there a process to rename the server?

It appears that @home requires me to use change my computer name. I am currently using a static IP, however remote access VNC, PCAynwhere are not working, including in-consistant ping results.

I would like to rename the MSSQL server, without having to face the msg that MSSQL is missing or corrupt.

Much grats for any assistance.

jEfFp...