6.5.1

Table Of Contents
4 (Optional) In the Description text box, enter an ODBC DSN description.
5 In the Server text box, enter the IP address or FQDN of the SQL Server and, if you want to use a
non-default port to access the SQL Server, enter a custom port separated by a comma.
For example, if the IP address of your SQL Server is 10.160.10.160 and you want to access the
server by using custom port 8347, enter 10.160.10.160,8347.
Note You cannot use a database server alias to create a DSN.
6 Select an authentication method.
n
Integrate Windows authentication.
Additionally, you can also enter the Service Principal Name (SPN).
Important You cannot use this option if the vCenter Server service is running under the
Microsoft Windows built-in system account.
n
SQL Server authentication.
Enter your SQL Server login name and password.
7 Select the database created for the vCenter Server system from the Change the default database
to menu.
8 Click Finish.
9 Test the data source by selecting Test Data Source and clicking OK from the ODBC Microsoft SQL
Server Setup menu.
10 Verify that the SQL Agent is running on your database server.
Configure Microsoft SQL Server TCP/IP for JDBC
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.
vSphere Installation and Setup
VMware, Inc. 296