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.

About this task

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.