If the Microsoft SQL Server database has TCP/IP disabled and the dynamic ports are not set, the JDBC connection remains closed. The closed connection causes the vCenter Server statistics to malfunction. You can configure the server TCP/IP for JDBC.

This task applies to remote Microsoft SQL Server database servers. You can skip this task if your database is located on the same machine as vCenter Server.

Procedure

  1. Select Start > All Programs > Microsoft SQL Server > Configuration Tool > SQL Server Configuration Manager.
  2. Select SQL Server Network Configuration > Protocols for Instance name.
  3. Enable TCP/IP.
  4. Open TCP/IP Properties.
  5. On the Protocol tab, make the following entries.
    Enabled Yes
    Listen All Yes
    Keep Alive 30000
  6. On the IP Addresses tab, make the following selections.
    Active Yes
    TCP Dynamic Ports 0
  7. Restart the SQL Server service from SQL Server Configuration Manager > SQL Server Services.
  8. Start the SQL Server Browser service from SQL Server Configuration Manager > SQL Server Services.