System requirements

Before installing PATROL for Microsoft SQL Server, verify that the target computer meets the following installation requirements:

Note

To get complete compatibility information for BMC PATROL for Microsoft SQL Server, use the BMC Solution and Product Availability and Compatibility Utility on the Product Availability and Compatibility page.

Any information about UNIX ^® in the following table applies to any supported versions of Linux ^® unless otherwise specified.

Support for third-party products

To receive full support for a BMC product, you must have that product installed in a supported environment, as specified in the BMC product documentation. If a third-party vendor cancels support for one of its products (such as an operating system or subsystem), and that third-party product integrates or interacts with the BMC product you have licensed, you must upgrade to a supported version of that third-party product before BMC Customer Support can provide you with support for the affected BMC product. For further information, see BMC's product support policy. Open link

Requirements for installing PATROL for Microsoft SQL Server

Resource

Requirements

Comments

Operating system

Supports all Microsoft Windows operating systems supported by the PATROL Agent 11.3.01 system requirements Open link

On Win 2008 .Net framework 4.xx is mandatory for KM version 9.6.12 and later.

.NET framework

Version 3.5.xx to 4.xx

KM version

.NET version

9.6.00, 9.6.10, and 9.6.11

3.5.xx only

9.6.12 and later

3.5.xx to 4.xx

(Windows 2008 supports .NET 4.xx only)

Note:

Microsoft Visual C++ 2010 Redistributable package is a requirement, and it part of the .NET 3.5.xx/4.xx installation.

When package is still missing after .NET installation it must be installed separately.

Supported Microsoft SQL Server versions

32 or 64 bit, Standard or Enterprise edition, and clustered or non-clustered environment:

Microsoft SQL Server 2022
Microsoft SQL Server 2019
Microsoft SQL Server 2017
Microsoft SQL Server 2016
Microsoft SQL Server 2014
Microsoft SQL Server 2012
Microsoft SQL Server 2008

The Microsoft SQL Server that you want PATROL Agent to monitor must have SQL Server performance objects installed. These performance objects must be available to the BMC PATROL for Microsoft SQL Server KM for all the functions of the KM to operate.

OS accounts on Microsoft Windows

PATROL account for Microsoft Windows (used for PATROL for Microsoft SQL Server installation)

Use the following guidelines when setting up the PATROL Windows account:

Create a dedicated user account before you install PATROL Agent. This default account for PATROL Agent can be a local account or a domain account.
The account must be a member of the local Administrators group on the computer where the agent will reside.
The account on a domain controller must be a member of the domain Administrators group.
Do not use a built-in Administrator account.
If you are using a domain account, you must specify the Windows NT domain with the user name.
Stand-alone workgroup servers must use a local user account.
Servers that are trusted members of a domain can use a local or domain account.
If an Access Control List (ACL) is used to control access to the PATROL Agent, the default accounts must have configured privileges.

BMC TrueSight Presentation Server

10.7.00
10.5.00
10.1.00
10.0.00

Minimum hardware requirements

X32, 2 CPU, 4 GB RAM

Credentials

Microsoft Windows

Type	Requirements
Local monitoring	Member of Users group (lowest possible permission level)
Remote monitoring	Member of Administrators group on the remote Microsoft SQL Server host (Microsoft prerequisite for using WMI connection).

To validate Windows local and domain user permissions see, Validation of Windows user.

Microsoft SQL Server

Features	Requirements
Basic functionality	Grant Server role public to user Add the user to all databases Grant db_datareader role membership for system databases msdb and master to user Grant View server state permission to user
SQL Agent Job Failures parameter	Grant execution permission on object msdb.dbo.agent_datetime to user
Always-On parameters	Grant View any definition permission to user
Replication parameters	Grant Server role sysadmin to user
Log-Shipping parameters	Grant Server role sysadmin to user
Mirroring parameters	Grant Server role sysadmin to user Or Membership in the dbm_monitor fixed database role

To validate the Microsoft SQL Server see, Validation of MS SQL Server login.
Requirements are same for Local/Remote monitoring
Requirements are same for Integrated/Standard user

Security

Do not use Security level 3 or higher if you are using Enterprise Configuration or the PATROL Advisor.

These security levels require passwords to be entered every time the host is accessed.

The password can have special characters like @, $, and ' (single quotes).

BMC recommends to avoid the use of the following characters in the password:

Double quotation marks ( " )
Forward slash ( / )
Backward slash ( \ )

Note

BMC products are certified for use on supported operating system versions. BMC does not explicitly test for OS patches/updates that are released after a BMC product is released.

BMC products should work fine with minor updates to these supported operating systems. For assistance, please contact BMC Customer Support.