Changing SQL Server Name

Greetings,
I have an application that runs on SQL Server XXXX. I want to change the
name of the server to YYYY.
Other than changing references within the application, is there anything
else I need to do because of the Server name change?
Platform: Win 2000 Server/SQL Server 2000
Thanks in advance,
Don
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!After renaming a server, you also need to update the system table
references to the server name - something like:
sp_dropserver 'OldServerName'
go
sp_addserver 'NewServerName','local'
After executing the stored procedures, restart SQL Server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:
>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!|||Oh and the jobs. You can script out your jobs and then go through the
script and change the server name and replace the jobs with the new
jobs you have just scripted.
The sysjobs table has the originating_server column which has the
server name value stored in it. It will be referencing the old server
name when you rename the server.
-Sue
On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@.hotmail.com>
wrote:
>Greetings,
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>Platform: Win 2000 Server/SQL Server 2000
>Thanks in advance,
>Don
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!|||I've written an article on this particular topic:
http://www.karaszi.com/SQLServer/info_change_server_name.asp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"don larry" <donlarry17@.hotmail.com> wrote in message
news:%23w$LBrolEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Greetings,
> I have an application that runs on SQL Server XXXX. I want to change the
> name of the server to YYYY.
> Other than changing references within the application, is there anything
> else I need to do because of the Server name change?
> Platform: Win 2000 Server/SQL Server 2000
> Thanks in advance,
> Don
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thank you so much guys, i will implement all these steps.
Big Appreciation!
Don
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!