Re: Hostname change and SQL problem.

• Previous message: Annie: "Communication Link Failure"
• In reply to: Gary: "Hostname change and SQL problem."
• Next in thread: Gary: "Re: Hostname change and SQL problem."
• Reply: Gary: "Re: Hostname change and SQL problem."
• Messages sorted by: [ date ] [ thread ]

Date: Sun, 9 May 2004 06:27:23 +0530

Hi,

Execute the statement in Query analyzer if SQL SERVER is normal edition , if
it is MSDE from command prompt execute

OSQL -Sserver -Usa -Ppassword

1> sp_dropserver 'old_server_name',
2> go
1> sp_addserver 'new_server_name', 'local'
2>go

There is a slight error in your statement, Please execute the below commands
from Query Analyzer:-

 sp_dropserver 'old_server_name',
 go
 sp_addserver 'new_server_name', 'local'

Note:
sp_dropserver 'Old_server', 'droplogins'

This removes the remote server old_server and all associated remote logins
from the local SQL Server. But in your case
u have remove the local server and add a new one.

Thanks
Hari
MCDBA

"Gary" <reachus@netlink.info> wrote in message
news:4Xbnc.8664$nN6.5313@lakeread06...
> We have had to change the hostname on an SQL server (Blade and the balde
> moved chassis so name changed)
>
> It seems i need to run 2 stored procedures which are
> sp_dropserver 'old_name', 'droplogins'
> go
> sp_addserver 'new_name', 'local'
> go
> Assuming this is right I cannot find anyway to run these stored procedures
> as there seems ot be no interactiove SQL.
>
> Help please
>
> Gary
>
>
>

• Previous message: Annie: "Communication Link Failure"
• In reply to: Gary: "Hostname change and SQL problem."
• Next in thread: Gary: "Re: Hostname change and SQL problem."
• Reply: Gary: "Re: Hostname change and SQL problem."
• Messages sorted by: [ date ] [ thread ]