Identity Management Service › Connectors Guide › Connecting to Endpoints › Microsoft 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.