change the name of sql server with the change of computer name -- sql server new users

Hari Prasad
8/28/2005 7:50:31 AM

Hi,

Login into sql server using Query Analyzer and execute below commands,

sp_dropserver <old server name>
go
sp_addserver <newserver name>,local

After this stop and start sql server service

Note:-

For Named instance you can not rename the SQL Server name. Onky way is to
reinstall the SQL Server.

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

Micheal
8/29/2005 1:36:35 PM

Hi,

just suppose I have computer with the name "MICHEAL"

and I have installed sql server . after some time I need to change the
computer name from "MICHEAL" to "JOHN"

Now I need to change the sql server instance from "MICHEAL" to "JOHN" .
How I change the name of sql server instance .
because sql server is still working on prebious computer name.
and in some application which install on computer and working with sql
server need to change the sql server instance with the change of name of
computer.

Regards

Micheal

sql server new users : change the name of sql server with the change of computer name