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 task applies to remote Microsoft SQL Server database servers. You can skip this task if your database is local.

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

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.