My Oracle Support Banner

How to Connect To A SQL Server Named Instance (Doc ID 2416526.1)

Last updated on JULY 02, 2018

Applies to:

Oracle Java CAPS - Version 5.1.3 and later
Information in this document applies to any platform.

Goal

We need to connect to a SQL Server database that resides on a SQL server that has a named instance, from Jcaps 5.1.3 and Jcaps 6.

The connection is not successful though.

We have tried following JDBC connection settings:
 ServerName: sqlseerver\instancename
 PortNumber: 1234

Please let me know whether we can connect to a named SQL instance and if so, how to configure the JDBC properties?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.