Can I configure the JDBC driver to use the shared memory protocol

Question

I work in a very restrictive environment and I am trying to configure a Java application to connect to my local running instance of SQL Server.

Shared protocols, TCP / IP, and Named Pipe are allowed, but only the Shared Memory protocol is included as part of the Network Configuration for my instance of SQL Server. Therefore, whenever I try to establish a connection, I get an error,

"The connection is disconnected: connect. Check the connection properties, make sure that the instance of SQL Server is running on the host and accepts TCP / IP connections on the port and that no firewall blocks TCP connections to the port."

I am pretty sure because TCP / IP is not included in the instance. So, is there a way to tell the JDBC URL that shared memory should be used, or is this not possible?

Answer 1

If you are open to it, do you consider ODBC?

You can configure ODBC DS to use the Named Pipe, and then connect to it via the JDBC URL to:

"jdbc:odbc:DSName" 

Does it help?