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.

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.