Sunday, March 11, 2012

Changing server name

I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?
Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>

No comments:

Post a Comment