Figure 7-2 shows the taskpad view of the OnePoint database in SQL Enterprise Manager. These last four databases are the system databases and should not be tampered with. In here you will see the OnePoint database as well as the master, msdb, model, and tempdb databases. Once a server has been successfully registered in the console, you can expand it to the folder level and select the databases folder. The next two pages are the standard Summary page and then the Successfully Completed page. You can accept the default, which will add the server to the SQL Server Group top-level group.

For MOM database servers, you can always select the Windows Authentication option, assuming that you are logged on with administrator rights.Ĭlick Next to bring up the Select SQL Server Group to add the registered server. Selecting the SQL servers to connect toĬlick Next to bring up the Connect Using page to select the authentication to connect to the SQL Server that you specified in the previous step. homemomserver3 has been added.įigure 7-1. Select either the '(local)' entry or enter the name of the server that you want to administer, highlight it, and click Add to move it to the 'Added servers' column (see Figure 7-1). Proceed through the start page and the wizard presents you with a list of available SQL Servers. This launches the SQL Server Registration wizard. Right-click the SQL Server Group object in the SQL Enterprise Manager and select New SQL Server Registration. Surprisingly enough, the first time you launch this tool, it will not have a connection to a database serveryou have to register a SQL Server in the console to manage it. To start SQL Enterprise Manager on the MOM database server, select Start Programs Microsoft SQL Server Enterprise Manager.

Sql server enterprise manager