Hostname change and SQL problem.

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
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
>
>
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uEs16DWNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> 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[vbcol=seagreen]
> 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...
procedures
>
Not that simple.
I cannot seem to get SQL Analyser to start the old instance i.e blade-0-1-5
I can start instance and get access to blade-0-0-12 [The new hostname]
When I run
SELECT @.@.SERVERNAME
SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')
I get
blade-0-0-4
blade-0-0-12 NULL
I really am not sure where the blade-0-0-4 is coming from .
Do I execute the SP's from the current hostname instance (blade-0-0-12)
Gary