Configuring a SQL Server

This section describes how to configure a SQL Server by supplying information about it. See System Requirements. PATROL records the information provided in the PATROL Agent configuration database.

This section provides the following tasks:

• To  open the SQL Server Instance Setup dialog box
• To  configure the login used by PATROL that has system administrator privileges
• To  configure the login used by PATROL that has user privileges
• To  verify the accounts and close the dialog box

These tasks assume that you have completed the following tasks:

• Loaded PATROL for Microsoft SQL Server.
• Verified that the SQL Server instance is discovered and online. For more information about pre-requisites for instance discovery, referenced registry keys, and account permissions for the instance to be discovered, see Preparing for instance discovery.

If any of the following occurs, perform the tasks listed above:

• If the CheckConfiguration collector parameter is in alarm state.
• If you want to modify login used by PATROL that has system administrator privileges.
• If you want to modify login used by PATROL that has user privileges.

To open the SQL Server Instance Setup dialog box

Select KM Commands > KM Admin > Setup/Configure KM > SQL Server Instance Setup from the Server application pop-up menu.

The SQL Server Instance Setup dialog box is displayed as shown in the following figure.


PATROL for Microsoft SQL Server automatically detects the security mode of the SQL Server and displays only the appropriate radio buttons in the SQL Server Instance dialog box.

• If the SQL Server is configured for integrated security, only the Integrated radio button is displayed.
• If the SQL Server is configured for standard security, only the Standard radio button is displayed.
• If the SQL Server is configured for mixed security, both the Standard and the Integrated radio buttons are displayed.

In the top half of the SQL Server Instance Setup dialog box is where you configure the login that BMC PATROL uses for those functions that require a System Administrator ( SA ) privilege.

In the bottom half of this dialog box, you configure the login that BMC PATROL uses for those functions that require User privileges.

For more information, see System-requirements.

To configure the login used by PATROL that has system administrator privileges

1. If your SQL Server is configured for mixed security, click either Standard or Integrated as the security mode to use with this login.
2. Enter the user name for the system administrator ( sa) account that PATROL for Microsoft SQL Server needs to monitor your Microsoft SQL Server installation.

3. Enter and reenter the password for the sa account.

   Warning

   Note

   If you chose Integrated security, you must enter a valid Windows login account (as shown in the figure).

4. If you chose Integratedsecurity for the sa account:
   • If the Windows login account you entered in Step 3 does not already have the required sa privilege, click Yes in the Grant admin. privilege to this login? field.
   • If the specified Windows login account you entered in Step 3 already has the sa privilege, click No in the Grant admin. privilege to this login? field.

To configure the login used by PATROL that has user privileges

1. If your SQL Server is configured for mixed security, click either Standard or Integrated in the Security mode to use with this login field.

2. Enter the user name for the PATROL account that PATROL for Microsoft SQL Server needs to monitor your Microsoft SQL Server installation.

   Warning

   Note

   If you chose Integrated security, the PATROL account must be a valid Windows login account.

3. Enter and reenter the password for the PATROL account.
4. If you chose Integrated security for the saaccount:
   • If the specified sa account does not have the system administrator privilege, click Yes in the Grant login to MS SQL Server? field.
   • If the specified sa account already has the system administrator privilege, click No in the Grant login to MS SQL Server? field.
5. To select whether you want PATROL to add a SQL Server login ID for the PATROL account, click Yes or No in the Add this login to MS SQL Server? field.
    If you chose Standard security for the PATROL account in Step1, and if you clicked No in Step 5, you must have already added a SQL Server login ID for the PATROL account.
    If you chose Integrated security for the PATROL account in Step 1, and if you clicked No in Step 4, the PATROL account automatically maps to the default login account that you specified when you configured the SQL Server security options. In addition, PATROL is only able to monitor the databases that use that default login account.

To verify the accounts and close the dialog box

1. To verify whether the accounts are correct, display a confirmation message, and keep the dialog box open, click Verify.
2. To close the dialog box, click Done.
    If the accounts are incorrect, a message is displayed and the dialog box stays open.