How to change SQL Server name..

[cricketer1]

How can I change the name of the database server with minimum disruptions. I already have some databases on it

Thanks

 

[cricketer1]

This is ok to chnage the database name, but I want to change the name of the Server.

thx
cricketer1

 

[olemma]

cricketer1,
I just did this twice during the last month. Just rename the server name (change ip, any dns entry, etc. if necessary), and reboot your server. The sql server service should come back up with the new server name.

BTW, you will need to run change the server name in msdb.sysjobs so any sql agent job that you have schedule continues to run.

Hope this helps.
olemma

 

[Patrick2002]

Read books online on topics "sp_dropserver" and "sp_addserver". If you don't use these stored procs after renaming the machine, the system tables will still contain the old servername. If your server has the same name as the machine, use the 'local' parameter in sp_addserver. Use "select @@servername" in the query analyzer to confirm the server has been renamed properly. You will see, if you do this after renaming the machine and rebooting, it still returns the old servername. Do the dropserver/addserver routine, and all will be correct.
Greetings from Patrick

 

[cricketer1]

Thanks, your replies helped.