a server with this name already exists?

Hi SQL Guru's
I have installed sql server 2000 on a new server. Our old server was called
SQL01 and I installed the new server as SQL01 as well (but just not on the
network to avoid the name clash)
I have now removed the old SQL01 server, put the new one in and changed the
IP Address so everything is the same as the old one. When I open EM on the
server itself and try and register it as SQL01 (it is currently local) I get
the error meesage "A Server with this name already exists" and I cannot
register the server.
I can connect to it remotly fine and setup my remote EM with the name SQL01
without any problems, but as soon as I try on the server I get that error.
Firstly does anyone know how to resolve this. I think the new server has
somehow learned about the old one and has remembered it so it won't let me
add this one with the same name. I have tried rebooting it and still does
this, so it's like it's cached the setting somewher and I need to remove
that so I can regoster it correctly.
Thanks for any help.Teddy
Look at sp_addserver and sp_dropserver stored procedures in the BOL
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>|||A server name can only be registered once in SEM... Delete the other server
registration, THEN add the new registration...( I mean delete the LOCAL
registration first.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>