System Requirements (Microsoft SQL Server)

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

For compatibility between products, please refer to:

vRealize 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) See: Assigning MS SQL User Privileges for information about creating the least amount of permissions for a MS SQL monitoring user. If using SSL, see: Adding an SSL Certificate to the vROps Truststore (Microsoft SQL Server).

Important:

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