To understand what is Enterprise Manager, you will have to understand what is Microsoft Management Console (also known as MMC). With the help of Microsoft Management Console it will be possible for you to manage different Applications of the Server in a Network of Microsoft Windows. A component which is known as MMC snap-in i.e. Microsoft Management Console snap-in is provided by different Server Applications. You will get an User Interface which will allow you to Manage Server Applications if you get MMC snap-in.
Microsoft Windows Dedicated Server Hosting
Now, comes the role of Enterprise Manager. Enterprise Manager is the MMC snap-in of Microsoft SQL Server. Enterprise Manager is the Tool which will allow you to Perform Administrative tasks for SQL Server. Now to perform the Administrative tasks, you will have to connnect to MSSQL Database through Enterprise Manager on your Windows Dedicated server. You can do this by following the simple steps given below :-
Windows Server 2003
1. Open Enterprise Manager on your Windows Dedicated server.
2. Then, to reach Local you will have to expand the list on the Panel which is on the Left side.
3. Find this option, ‘(local) (Windows NT)’ and finally select ‘New SQL Server Registration’.
4. Now, you will have to Enter the IP address of your Windows Dedicated server.
Note :- Make sure that you Enter the Primary IP address of your Windows Dedicated server, otherwise, it may cause problems.
5. Select the 2nd option now when asked to select an Authentication mode.
6. Now, for the Connection options, select ‘Login Automatically’ and provide the login information i.e. ID and password when you are asked for it.
7. You will be asked to select a Connection Group now. It is also possible to create a new one.
Note :- This is basically done to keep things functioning in a proper manner. If you choose another inspite of having one, it won’t affect your Connection.
8. Once you are done with the 7th step above, simply click on the Finish option and you are done.
Now, you will be provided with an MMC-compliant user which is an Interface which will allow you to perform the following tasks :-
1) Bring together Individual servers and make a group of servers.
2) Determine and form Groups of SQL server instances.
3) Create different SQL Servers for each Registered Server.
4) Administration of all the SQL Server databases of different Registered Servers and manage all SQL server databases, Logins, Permissions, Users, Objects etc.
5. Determine and work on all SQL server tasks on each separate server.