May 3, 2006 at 12:51 pm
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.
May 3, 2006 at 1:31 pm
Where are you creating these?
May 3, 2006 at 2:11 pm
In the same server.
May 3, 2006 at 2:25 pm
No what I meant is in SQL Logins? Or Database Roles? What do you mean by Group exactly?
May 3, 2006 at 2:40 pm
an Instance (In Oracle term). a group a databases. not logins or roles.
May 3, 2006 at 2:51 pm
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.
May 3, 2006 at 4:39 pm
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
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