Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Connecting to SQL Server from Java over TCP/IP

DZone's Guide to

Connecting to SQL Server from Java over TCP/IP

· Java Zone
Free Resource

Build vs Buy a Data Quality Solution: Which is Best for You? Gain insights on a hybrid approach. Download white paper now!

Been a while since I did this; turns out it’s easy enough.

First, you’ll need the current JDBC driver from Microsoft, which can be found here.  Add to classpath as usual.

Set up your Java application to use the following JDBC connection settings:

  • ConnectionDriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver
  • ConnectionURL=jdbc:sqlserver://127.0.0.1:1433;instance=SQLEXPRESS;databaseName=jdo;
  • ConnectionUserName=jdo
  • ConnectionPassword=jdopass

In this case I’m connecting to SQLExpress instance running on my localhost.

The trickiest bit (for me) was figuring out how to persuade SQL Server to listen over TCP/IP – by default it only seems to listen over shared memory.  Anyway, after a bit of trial and error, the following worked.

First, locate SQL Server Configuration Manager, and enable TCP/IP for the SQL Server instance (SQLExpress in this case).

image

Then, right-click to open up the properties for TCP/IP, and set the port for IPAll at the bottom:

image

You should then be able to connect.

Build vs Buy a Data Quality Solution: Which is Best for You? Maintaining high quality data is essential for operational efficiency, meaningful analytics and good long-term customer relationships. But, when dealing with multiple sources of data, data quality becomes complex, so you need to know when you should build a custom data quality tools effort over canned solutions. Download our whitepaper for more insights into a hybrid approach.

Topics:

Published at DZone with permission of Dan Haywood, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}