Connecting to JDBC connections (SQL) with multiple instances

SQL Server allows for the installation of multiple database instances per server. A specific name identifies each instance. To connect to a named instance of SQL Server, you can specify the port number of the named instance (preferred), or you can specify the instance name as a JDBC URL property or a data source property. If no instance name or port number property is specified, a connection to the default instance is created.

Note: When connecting to a specific instance on a SQL Server, you should use either the port number OR the instance name. Using both variables will cause a connection error, as the component will only accept one or the other.

In addition to multiple SQL Server instances, you need to set one of the following properties:

• To use a port number, enter the following:

  • jdbc:sqlserver://localhost:1433;integratedSecurity=true;<more properties as required>

• To use a JDBC URL property, enter the following:

  • jdbc:sqlserver://localhost;instanceName=instance1;integratedSecurity=true;<more properties as required>