The vCenter Server installer generates and validates the JDBC URL for the vCenter Server database. If the installer fails to connect to the database using the generated JDBC URL, the installer will prompt you to specify the JDBC URL.

For Microsoft SQL Server databases, you can use the following example JDBC URLs as a model:

Connect to default (unnamed) SQL Server instance by host name:

jdbc:sqlserver://host;databaseName=database

Connect to named instance by host name and instance name:

jdbc:sqlserver://host;instanceName=instance;databaseName=database

Connect to SQL Server by host name and port:

jdbc:sqlserver://host:port;databaseName=database

Connect by port:

jdbc:sqlserver://localhost:1422;databaseName\=VIM_VCDB (user name, password, and database type to be passed separately)

Connect to local server with integrated security:

jdbc:sqlserver://localhost\\SQLEXP_VIM;databaseName=VIM_VCDB;integratedSecurity=true

Connect to local server without integrated security:

jdbc:sqlserver://localhost\\SQLEXP_VIM;databaseName\=VIM_VCDB (user name, password, and database type to be passed separately)

VMware vCenter Server JDBC configuration for Microsoft SQL Server might not work by default with direct IPv6 addresses. You must use one of the following forms:

Use the host name form for a standard Type-4 JDBC URL (recommended):

jdbc:sqlserver://database-fully-qualified-host-name:port

Use direct IPv6 address format:

jdbc:sqlserver://;serverName=[IPv6-address]

For more information about JDBC URL formatting for MS SQL databases, including port and instance configuration options, see the msdn.microsoft.com Web site. At the time of this topic's publication, the information was available at http://msdn.microsoft.com/en-us/library/ms378428.aspx.

For Oracle databases, you can use the following example JDBC URLs as a model:

This format requires host name and address, port (default 1521) and service name (for example, "oracle.world"):

jdbc:oracle:thin:@host:port/service

This format requires host name and address, port (default 1521) and SID (for example, "ORCL"):

jdbc:oracle:thin:@host:port:SID

This format is for a fully configured Oracle client with Oracle Net, which is useful for non-TCP configuration or Oracle RAC (real application clusters):

jdbc:oracle:thin:@tnsname

The following example is for an Oracle RAC with a thin driver, without the full Oracle client installed:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=ON)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RAC.DBTEAM)(FAILOVER_MODE=(BACKUP=rac1)(TYPE=SELECT)(METHOD=BASIC)))))

In this example, rac1-vip is first node virtual IP, rac2-vip is second node virtual IP, RAC.DBTEAM is RAC DB service name, and rac1 is name of failover node.

For more information about JDBC URL formatting for Oracle databases, see the oracle.com Web site. At the time of this topic's publication, the information was available at http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/urls.htm/BEIJFHHB

For IBM DB2 databases, you can use the following example JDBC URLs as a model:

This format requires host name and address, port (for example, 50000) and database name (as created at the server):

jdbc:db2://host:port/database

This format is for a fully configured DB2 client (namely "IBM Data Server Client"), where database is the local database alias. This example is useful for non-TCP configurations:

jdbc:db2:database

For more information about JDBC URL formatting for IBM DB2 databases, see the publib.boulder.ibm.com Web site.