JDBC-ODBC - Configuring SQL Server for TCP/IP Connection

JDBC for SQL Server - Herong's Tutorial Examples

∟JDBC-ODBC Bridge Driver - MS SQL Server

∟JDBC-ODBC - Configuring SQL Server for TCP/IP Connection

This section describes how to configure SQL Server for TCP/IP connections.

As the first test, I want to try JDBC-ODBC Bridge with the SQL Server 2005 Express Edition on my local machine. To prepare for ODBC connect, I need to make two changes to my SQL Server:

Start SQL Server Browser Service (installed as part of SQL Server) on my local machine.
Enable the TCP/IP protocol support on my SQL Server.

Starting SQL Server Browser Service can be easily done by using the "Services" program in the Control Panel.

Enabling the TCP/IP protocol support on my SQL Server can be done with SQL Server Configuration Manager. Go to the "Protocols for SQLEXPRESS" and enable "TCP/IP" with the context menu. Then look at the "TCP/IP" properties. You will find the port number, 1269, the SQL Server is using to listen ODBC connections.