Before installing and configuring the Management Pack for Microsoft SQL Server, ensure your system meets the following requirements:

vRealize Operations (vROps) Requirements Microsoft SQL Server Requirements
Version(s) vRealize Operations 7.x & 8.x (Enterprise edition only)

Microsoft (MS) SQL Server, versions:

  • 2017
  • 2016
  • 2014
  • 2012
  • 2008 R2

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.

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.