Before installing and configuring the Management Pack, ensure your system meets the following requirements.

For compatibility between products, please refer to:

VMware Aria Operations Interoperability for Microsoft SQL Server

-OR-

Third Party Solution Interoperability for Microsoft SQL Server

Microsoft SQL Server Requirements

Connection

Standalone Configuration:

  • Hostname (or IPv4 address) of MS SQL Server instance

Clustered Configuration:

  • Virtual IP (VIP), or hostname for the VIP, of MS SQL Server instance

Default Instance Port: 1433 (TCP)

Important:

If using dynamic ports, you will want to change the default port to SQL Server Browser Service UDP port 1434. For more information, see Microsoft's Configure the Windows Firewall to Allow SQL Server Access documentation topic.

Credentials

MS SQL User Name/Password (Active Directory or Local)

Important:

The CPU Usage metric for Microsoft SQL Server Instances is not available on MS SQL Server Standard or Express editions.