Administer Operator Categories and Custom Operator Groups › Configuring Operator Categories › Configure Databases: Default MSSQL Server Properties

Configure Databases: Default MSSQL Server Properties

You can configure the Databases category of operators for MSSQL Server.

Follow these steps:

1. Click the Configuration tab, select Domain, and click Lock.
2. Click the Modules tab, right-click Databases, and select Edit.
3. Click the Default MSSQL Server Properties tab.
4. Accept com.microsoft.sqlserver.jdbc.SQLServerDriver as the default driver for MSSQL Server.
5. Enter the host name or IP address of the host where the MSSQL Server is running, to use as the default.
6. Enter the default MSSQL Server port (typically 1433).
7. Specify default credentials for the MSSQL database user.
   • Enter a user name.
   • Enter the password that is associated with the specified user name.
8. Accept the default maximum number of rows to retrieve (10), or select another value up to 512.
9. Enter the default MSSQL database name.
10. Enter the default MSSQL instance name.
11. Click Save and Close.
12. Click Save.
13. Select Domain and click Unlock.

More information:

Override Settings Inherited by a Category of Operators

Category Configuration and Operator Inheritance

About Databases

Configuring Operator Categories