# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# MS SQL Server JDBC Driver and URL Information

Listed below are connection examples for common JDBC drivers for Microsoft SQL Server: jTDS Driver

DRIVER CLASS: net.sourceforge.jtds.jdbc.Driver
DRIVER LOCATION: Specify the location on your machine of the jar file containing the jTDS driver.
JDBC URL FORMAT: jdbc:jtds:sqlserver://<host>:<port>/<database_name>
The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.
Examples:
jdbc:jtds:sqlserver://neptune.acme.com:1433/test
jdbc:jtds:sqlserver://127.0.0.1:1433/test
Microsoft SQL Server 2005 JDBC Driver

DRIVER CLASS: com.microsoft.sqlserver.jdbc.SQLServerDriver
DRIVER LOCATION: Specify the location on your machine of the Microsoft SQL Server driver. See your Microsoft SQL Server driver documentation for more details. Certain versions of the Microsoft SQL Server driver require more than one jar file for the driver location. In this case, simply separate each file location by a semi-colon.
JDBC URL FORMAT: jdbc:sqlserver://<server_name>:<port>
The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.
Examples:
jdbc:sqlserver://neptune.acme.com:1433
jdbc:sqlserver://127.0.0.1:1433
Microsoft SQL Server JDBC Driver

DRIVER CLASS: com.microsoft.jdbc.sqlserver.SQLServerDriver
DRIVER LOCATION: Specify the location on your machine of the Microsoft SQL Server driver. See your Microsoft SQL Server driver documentation for more details. Certain versions of the Microsoft SQL Server driver require more than one jar file for the driver location. In this case, simply separate each file location by a semi-colon.
JDBC URL FORMAT: jdbc:microsoft:sqlserver://<server_name>:<port>
The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.
Examples:
jdbc:microsoft:sqlserver://neptune.acme.com:1433
jdbc:microsoft:sqlserver://127.0.0.1:1433