Renaming the server name? How could I do such thing?

10 Feb 2006 1:43 PM

Enric

Dear all,

I would need to rename the name of the server.
any comments will be welcomed.

--
current location: alicante (es)

10 Feb 2006 1:48 PM

Ryan

Renaming the server is done at the OS level, System Properties, Computer
Name

It may affect the SQL installation.

The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services

At this stage, select @@SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.

--
HTH. Ryan

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com...
> Dear all,
>
> I would need to rename the name of the server.
> any comments will be welcomed.
> --
> current location: alicante (es)

10 Feb 2006 1:52 PM

Ryan

BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete

http://support.microsoft.com/kb/303774/en-us

--
HTH. Ryan

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com...
> Dear all,
>
> I would need to rename the name of the server.
> any comments will be welcomed.
> --
> current location: alicante (es)

10 Feb 2006 3:22 PM

Tibor Karaszi

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/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Ryan" <Ryan_Waight@nospam.hotmail.com> wrote in message
news:OgvDCmkLGHA.3260@TK2MSFTNGP11.phx.gbl...
> BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete
>
> http://support.microsoft.com/kb/303774/en-us
>
> --
> HTH. Ryan
>
>
> "Enric" <En***@discussions.microsoft.com> wrote in message
> news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com...
>> Dear all,
>>
>> I would need to rename the name of the server.
>> any comments will be welcomed.
>> --
>> current location: alicante (es)
>
>