Page History

...

1. If you want to monitor an Oracle or Db2 instance, you must select Oracle. If you want to monitor a SQL Server and/or a Sybase instance, select one of the Microsoft SQL Server options. 

   Info
   The Microsoft SQL Server (Using OS authentication) option is enabled only when all the Framework servers are Windows servers, and the service authentications are either all configured to run with a user or are all set to the local system. If they are set to the local system, the service authentication is the user provided in the next step.

2. Click Next.

Using an Oracle PMDB

Using a Microsoft SQL Server PMDB

To enter Microsoft SQL Server PMDB login information (using OS authentication)

...

1. In the SQL Server instance field, click the drop-down menu, and then select the SQL Server instance from the list, or type in a different instance. The selected Microsoft SQL Server instance is used as the PMDB.
2. Type the Login Name. The login name is used both for the PMDB installation, as well as for connecting to the SQL server when using the PMDB.
3. Type the Password for the login name specified.
4. Type the name of the database you want the PMDB to use. If a database with that name already exists, it is used. If not, a new database is created. For a new database, complete the data path and log path fields.
5. By default, the PMDB schema is automatically installed. To install the schema manually, see Manually installing the SQL Server PMDB schema.
6. Click Next.

Completing the new database properties

The New Database Properties tab of the Advanced window allows you to enter properties for the new database.

Image Added

To change the new database properties

1. In the PMDB Instance Parameters screen, click Advanced.
2. In the New Database Properties tab, complete the following fields:
   1. Collation
   2. Datafile Initial Size (MB)
   3. Datafile Autogrowth (MB)
   4. Log File Initial Size (MB)
   5. Log File Autogrowth (Percent)
3. Click OK.

Manually installing the SQL Server PMDB schema To manually install the PMDB schema On the PMDB Instance Parameters screen, click Advanced. In the Schema tab, mark the Disable automatic schema installation check box. If the database contains partitioning, mark the Database contains partitioning check box.