User`s guide

Microsoft SQL Server JDBC for Windows
2-33
Microsoft SQL Server JDBC for Windows
This tutorial shows how to set up a data source and connect to your Microsoft SQL Server
database. This tutorial uses the Microsoft JDBC Driver 4.0 for Microsoft SQL Server to
connect to the Microsoft SQL Server 2012 Express database.
In this section...
“Step 1. Verify the driver installation.” on page 2-33
“Step 2. Verify the port number.” on page 2-33
“Step 3. Set up the operating system authentication.” on page 2-36
“Step 4. Add the JDBC driver to the MATLAB static Java class path.” on page 2-37
“Step 5. Set up the data source using Database Explorer.” on page 2-38
“Step 6. Connect using Database Explorer or the command line.” on page 2-40
Step 1. Verify the driver installation.
If the JDBC driver for Microsoft SQL Server is not installed on your computer, find
the link on the Driver Installation page to install the driver. Follow the instructions to
download and install this driver on your computer.
Step 2. Verify the port number.
To connect to your database using a JDBC driver, you must know the port number. Use
the following steps on the machine where Microsoft SQL Server is installed to find your
port number. If you experience connection issues with the port number that you find,
contact your database administrator.
1
On the machine where your Microsoft SQL Server database is installed, click Start.
Select your Microsoft SQL Server version folder and click Configuration Tools.
Then click SQL Server Configuration Manager.