Creating a new server in an existing server group

(SQL 2000)
Hi,
I'm trying to create a new server in an existing server group, however there
doesn't seem to be an option to do this. The closest I can see is "New SQL
Server registration" but when I try to use this I need to pick from a list o
f
existing servers. If I type in a new server name I get a status message
saying: SQL server doesn't exist or access denied. I have sa permissions so
I
doubt it would be a permissions issue.
Any ideas as to what I might be doing wrong?
Many thanks for any ideas on this in advance
AntHi
"Ant" wrote:

> (SQL 2000)
> Hi,
> I'm trying to create a new server in an existing server group, however the
re
> doesn't seem to be an option to do this. The closest I can see is "New SQL
> Server registration" but when I try to use this I need to pick from a list
of
> existing servers. If I type in a new server name I get a status message
> saying: SQL server doesn't exist or access denied. I have sa permissions s
o I
> doubt it would be a permissions issue.
If you right click on the Server Group you wish to add to, then you can
choose the New Server Registration option and type in the name of the new
server rather than browse for it. As the server is not on the list then it
may not have the network protocols enabled. This could be the reason for you
r
error message. Try connecting to the server using Query Analyser (both
locally and on the server itself) and see if you get this message. You can
check the protocols enabled by using the Server Network Utility on the
server. You may also want to make sure that the appropriate Service Packs
have been applied to this SQL Server instance (SELECT @.@.VERSION).

> Any ideas as to what I might be doing wrong?
> Many thanks for any ideas on this in advance
> Ant
>
John|||hi
try this:
go to start->programs->Microsoft SQL->client network utility (CNU)
on the CNU create an alias using tcp protocol, and specify the port number
that the sql instance is using (default is 1433)
on the name for the alias use a friendly name, so it's easy to use.
go to the sql enterprise manager, right click on the server group where you
want to add the sql instance, and use the alias friendly name you used on th
e
CNU.
and that's it.
Paulo Ferreira
http://www.info2k.pt
SQL Server DBA Experts