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

This procedure applies to remote Microsoft SQL Server database servers. You can skip this procedure if your database is local.

1

Start the SQL Server Configuration Manager by selecting Start > All Programs > Microsoft SQL Server > Configuration Tools > 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 selections.

Option

Action

Enabled

Select Yes.

Listen All

Select Yes.

Keep Alive

Enter 30000.

6

On the IP Addresses tab, make the following selections.

Option

Action

Active

Select Yes.

TCP Dynamic Ports

Select 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.