Renaming Server

Renaming Server

Post by Tony » Fri, 19 Apr 2002 01:31:52



Can I change the name of a Server after I load SQL?

Thanks

Tony

 
 
 

Renaming Server

Post by Narayana Vyas Kondredd » Fri, 19 Apr 2002 01:51:37


Yes you can. First rename the machine, and follow the instructions at:
http://vyaskn.tripod.com/administration_faq.htm#q5 depending on your SQL
Server version.

--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


Quote:> Can I change the name of a Server after I load SQL?

> Thanks

> Tony


 
 
 

Renaming Server

Post by Steve Thompso » Fri, 19 Apr 2002 01:51:13


Yes you can -

sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName','local'
go
Steve

Quote:> Can I change the name of a Server after I load SQL?

> Thanks

> Tony

 
 
 

Renaming Server

Post by Steve Thompso » Fri, 19 Apr 2002 01:53:09


Quote:> Can I change the name of a Server after I load SQL?

Too quick on the send :) You'll need to stop/restart the MSSQLServer service

 
 
 

Renaming Server

Post by Dinesh T » Fri, 19 Apr 2002 01:57:13


Tony,

Yes.For SQL7 and 2000 the procedures vary.
I have listed them in
http://www.tkdinesh.com/faq/ans/rename.html

Dinesh.


Quote:> Can I change the name of a Server after I load SQL?

> Thanks

> Tony