Create another server group in the same server

  • Hi,

       Can someone guide me for how to create another server group in SQL Server 2000 Enterprise Manager?

    I have registered one SQL Server "SVDEV01", but now I want to create a separate SQL Server Group and the name will be "SVDEV01_2".  Can I do it?  How?

    Thank you.

  • Where are you creating these?

  • In the same server.

  • No what I meant is in SQL Logins? Or Database Roles? What do you mean by Group exactly?

  • an Instance (In Oracle term).  a group a databases. not logins or roles.

  • OK if you are referring to creating a new installed instance of SQL Server on the machine:

    You basically run the install and following the same steps except make sure you place your files in a different path.

    See BOL for more details on instances.

    But now this is a seperate database server you are setting up.

    If we are talking just EM settings and not a new install:

    If you mean a SQL Group in your Enterprise Manager only then you just right click on "Microsoft SQL Servers" and select "New SQL Server Group..." and give it a name and you can register servers under it.

    If you are just trying to register another server with a different name (even if the same server) you just follow the steps you did for the other, however you most likely will need to create another alias so open "Client Network Utility" and create and alias for the server you need, this way you can use that alias in you server registration in EM.

    Unfortunately you statement leaves several things to be assumed.

  • I think Jennifer is asking about the registration group. Right-click on the top-most entry  in EM and select to create a new group from the context menu. See

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_servpem_7jua.asp

    How to create server groups (Enterprise Manager)

    Regards,Yelena Varsha

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply