Connecting to SQL Server from Java over TCP/IP
Connecting to SQL Server from Java over TCP/IP
Join the DZone community and get the full member experience.
Join For FreeTake 60 minutes to understand the Power of the Actor Model with "Designing Reactive Systems: The Role Of Actors In Distributed Architecture". Brought to you in partnership with Lightbend.
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).
Then, right-click to open up the properties for TCP/IP, and set the port for IPAll at the bottom:
You should then be able to connect.
Learn how the Actor model provides a simple but powerful way to design and implement reactive applications that can distribute work across clusters of cores and servers. Brought to you in partnership with Lightbend.
Like This Article? Read More From DZone
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.linkDescription }}
{{ parent.urlSource.name }}