Connector Guides › Connectors Guide › Database Connectors › MS SQL Server Connector › MS SQL Configuration › Configure the JDBC URL

Configure the JDBC URL

Communication between the Provisioning server and the MS SQL server relies on a JDBC connection. A URL specifies connection details to each server, as illustrated in the following examples:

• Basic URL

  jdbc:sqlserver://serverHost

• Integrated Security URL

  jdbc:sqlserver://serverHost;integratedSecurity=true

• Named instance on port 1433 URL

  jdbc:sqlserver://serverHost:1433;instanceName=instance1

• Connecting with IPv6

  jdbc:sqlserver://;serverName=<IPv6 address here>

  jdbc:sqlserver://;serverName=<IPv6 address>;port=CA Portal;databaseName=<DB>

Note: For more details see Building the Connection URL on MSDN.