VMware VS4-ENT-PL-A Setup Guide - Page 41
Con Microsoft SQL Server TCP/IP for JDBC
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 41 highlights
Chapter 3 Before You Install vCenter Server 4 (Optional) Type an ODBC DSN description in the Description text box. 5 Select the server name from the Server drop-down menu. Type the SQL Server host name in the text box if it is not in the drop-down menu. 6 Select one of the authentication methods. n Integrate Windows authentication. Optionally, enter the Service Principal Name (SPN). n SQL Server authentication. Type 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 For SQL Server 2005 and SQL Server 2008 editions, 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 local. 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. What to do next Optionally, you can enable Database Monitoring for Microsoft SQL database users. Otherwise, install vCenter Server. VMware, Inc. 41