On Sql Server 2000,

MSDN says to change the name of the instance you do:

sp_dropserver old_servername\instancename
GO
sp_addserver new_servername\instancename, local
GO

I tried to do this as:

sp_dropserver 'PTERADON\AW3000_INSTANCE'
GO
sp_addserver 'PTERADON\SQL2000', local
GO

and sysserver shows that the change was made.

But the EM still shows the old server and the old name if I try to delete
the Server Registration and add it back in under the new name.

It still functions as the old name fine.

How do I get it to work?

Thanks,

Tom

> I tried to do this as:
>
> sp_dropserver 'PTERADON\AW3000_INSTANCE'
> GO
> sp_addserver 'PTERADON\SQL2000', local
> GO

This changes the internal instalnce name (@@SERVERNAME) but not the actual
(external) instance name. Unfortunately, the only way to change the
instance name is to uninstall, re-install with the desired name and
re-attach or restore the databases. After you restore/replace the master
database, you will need to use sp_dropserver/sp_addserver.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"tshad" <tfs@dslextreme.com> wrote in message
news:%23MFpPT9EJHA.1272@TK2MSFTNGP02.phx.gbl...
> On Sql Server 2000,
>
> MSDN says to change the name of the instance you do:
>
> sp_dropserver old_servername\instancename
> GO
> sp_addserver new_servername\instancename, local
> GO
>
> I tried to do this as:
>
> sp_dropserver 'PTERADON\AW3000_INSTANCE'
> GO
> sp_addserver 'PTERADON\SQL2000', local
> GO
>
> and sysserver shows that the change was made.
>
> But the EM still shows the old server and the old name if I try to delete
> the Server Registration and add it back in under the new name.
>
> It still functions as the old name fine.
>
> How do I get it to work?
>
> Thanks,
>
> Tom
>

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:u1WUev$EJHA.2292@TK2MSFTNGP04.phx.gbl...
>> I tried to do this as:
>>
>> sp_dropserver 'PTERADON\AW3000_INSTANCE'
>> GO
>> sp_addserver 'PTERADON\SQL2000', local
>> GO
>
> This changes the internal instalnce name (@@SERVERNAME) but not the actual
> (external) instance name. Unfortunately, the only way to change the
> instance name is to uninstall, re-install with the desired name and
> re-attach or restore the databases. After you restore/replace the master
> database, you will need to use sp_dropserver/sp_addserver.

I guess you are right.

The article: http://msdn.microsoft.com/en-us/libr...1(SQL.80).aspx

was talking about getting the sysservers table to match the new name (which
I assume would be the machine name and the instance would still have the
same name).

Thanks,

Tom
>
> --
> Hope this s.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
> "tshad" <tfs@dslextreme.com> wrote in message
> news:%23MFpPT9EJHA.1272@TK2MSFTNGP02.phx.gbl...
>> On Sql Server 2000,
>>
>> MSDN says to change the name of the instance you do:
>>
>> sp_dropserver old_servername\instancename
>> GO
>> sp_addserver new_servername\instancename, local
>> GO
>>
>> I tried to do this as:
>>
>> sp_dropserver 'PTERADON\AW3000_INSTANCE'
>> GO
>> sp_addserver 'PTERADON\SQL2000', local
>> GO
>>
>> and sysserver shows that the change was made.
>>
>> But the EM still shows the old server and the old name if I try to delete
>> the Server Registration and add it back in under the new name.
>>
>> It still functions as the old name fine.
>>
>> How do I get it to work?
>>
>> Thanks,
>>
>> Tom
>>
>

"tshad" <tfs@dslextreme.com> wrote in message
news:udnt9WCFJHA.616@TK2MSFTNGP06.phx.gbl...
> "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
> news:u1WUev$EJHA.2292@TK2MSFTNGP04.phx.gbl...
>>> I tried to do this as:
>>>
>>> sp_dropserver 'PTERADON\AW3000_INSTANCE'
>>> GO
>>> sp_addserver 'PTERADON\SQL2000', local
>>> GO
>>
>> This changes the internal instalnce name (@@SERVERNAME) but not the
>> actual (external) instance name. Unfortunately, the only way to change
>> the instance name is to uninstall, re-install with the desired name and
>> re-attach or restore the databases. After you restore/replace the master
>> database, you will need to use sp_dropserver/sp_addserver.
>
> I guess you are right.
>
> The article: http://msdn.microsoft.com/en-us/libr...1(SQL.80).aspx
>
> was talking about getting the sysservers table to match the new name
> (which I assume would be the machine name and the instance would still
> have the same name).
>
> Thanks,
>
> Tom
>>
>> --
>> Hope this s.
>>
>> Dan Guzman
>> SQL Server MVP
>> http://weblogs.sqlteam.com/dang/
>>
>> "tshad" <tfs@dslextreme.com> wrote in message
>> news:%23MFpPT9EJHA.1272@TK2MSFTNGP02.phx.gbl...
>>> On Sql Server 2000,
>>>
>>> MSDN says to change the name of the instance you do:
>>>
>>> sp_dropserver old_servername\instancename
>>> GO
>>> sp_addserver new_servername\instancename, local
>>> GO
>>>
>>> I tried to do this as:
>>>
>>> sp_dropserver 'PTERADON\AW3000_INSTANCE'
>>> GO
>>> sp_addserver 'PTERADON\SQL2000', local
>>> GO
>>>
>>> and sysserver shows that the change was made.
>>>
>>> But the EM still shows the old server and the old name if I try to
>>> delete the Server Registration and add it back in under the new name.
>>>
>>> It still functions as the old name fine.
>>>
>>> How do I get it to work?
>>>
>>> Thanks,
>>>
>>> Tom
>>>
Hi

I am not sure why you want to change the name, would using an alias be an
option?

Look up "How to: Configure Client Protocols (SQL Server Configuration
Manager)" in Books online for more.

John