Microsoft JDBC Driver for SQL Server

JDBC Tutorials - Herong's Tutorial Examples

∟Microsoft JDBC Driver for SQL Server

This chapter provides tutorial notes on JDBC Driver produced by Microsoft for SQL Server. Topics include downloading and installing Microsoft JDBC Driver; loading driver JAR file; creating a connection to SQL Server with port number, instance name and database name; closing a connection.

Installing Microsoft JDBC Driver for SQL Server

Loading Driver Class Automatically

Loading Driver Class with Class.forName()

DriverManager.getConnection() and Connection URL

Enable TCP/IP with SQL Server Configuration Manager

Specifying Port Number in Connection URL

Instance Name Better than Port Number

Specifying Instance Name in Connection URL

Closing the Database Connection - con.close()

Specifying Database Name in Connection URL

Incorrect Database Name in Connection URL

Creating Connections with DataSource Class

Takeaways:

Microsoft offers a free JDBC driver for accessing MS SQL Server databases.
The connection URL for the Microsoft JDBC driver is "jdbc:sqlserver://server_name:port;database=name;user=login;password=****".
By default, the TCP/IP protocol is disabled on SQL Server instances.
You can enable the TCP/IP protocol on a SQL Server instance with SQL Server 2014 Configuration Manager. It will use a dynamic port number, like 60782, which will not match the default port number used in the JDBC Driver.
You can enable the SQL Server Browser service and use instance number instead of port number in the connection URL for a specific database instance.