MS SQL Server Connection Help
RazorSQL can connect to MS SQL Server via either JDBC or ODBC, and ships with the JDBC drivers necessary to connect to all recent versions of SQL Server including 2017, 2016, 2014, 2012, 2008, 2005, 2000, and 7.0. Users can connect via ODBC by setting up an ODBC data source for SQL Server on their machine via the Windows data sources control panel. See below for more information on each of these connection types.
Another option for connecting is via the ASP or PHP bridges. The bridges allow users to connect to remote SQL Server databases that do not allow remote access. This is often the case with web hosting providers. The web hosts provide access to SQL Server databases, but only locally from the web server. See the links below for more information on the bridges.
Connecting to MS SQL Server via JDBC
Before connecting to SQL Server via JDBC, there are some prerequisites that need to be met. The SQL Server database either needs to accept TCP/IP connections, or if the database is SQL Server 2005 or older, another option is for the server to be set to be able to communicate via Named Pipes. If the SQL Server database is not set up for either of these communication protocols, ODBC should be used to connect to the database. For Mac or Linux users, the TCP/IP protocol should be enabled in order for Mac / Linux users to be able to connect.
To connect to SQL Server via JDBC, open the connection wizard and select Microsoft SQL Server as the database type. For the driver type, there are two options - the MS SQL Server JDBC driver and the jTDS JDBC driver. If SSL is enabled on the MS SQL Server database, the jTDS driver may not be able to connect depending on how the database is configured. In that case, the MS SQL Server JDBC driver should be used
The next step is to enter the appropriate login information. There are several options.
Windows Single Sign On: If you are on a Windows machine and using the jTDS driver, it is possible to attempt to login via Windows Single Sign on. This option attempts to login to SQL Server using the login credentials of the current logged on user of the operating system.
Windows Authentication: If you have a login id and password for the Windows domain on which SQL Server is running, you can use this option by entering the login, password, and Windows domain. RazorSQL will then send this information to SQL Server for authentication.
SQL Server Authentication: If you have a user id and password for the SQL Server database, this option can be used.
After entering the sign on information, the host, port, and database name needs to be entered to connect to SQL Server.
Host or Ip Address: This is the host name or ip address of the MS SQL Server database.
Port: This is the network port on which SQL Server is listening if the SQL Server database accepts TCP/IP connections. If using named pipes, or if the server is listening on the default port, this field can be left blank.
Database Name: This is the name of the database you wish to work with. For example, master or sample, etc.
Connecting to MS SQL Server via ODBC
There are a couple of options for connecting to SQL Server via ODBC. Microsoft provides the newer SQL Server Native client ODBC driver, and there is also the older SQL Server 6.0 ODBC driver that can be used. Either of these options should allow you to connect to SQL Server via ODBC with RazorSQL.
For more information about setting up an ODBC data source, see the following link:
Manual SQL Server JDBC Information
If manually configuring your connection for JDBC, see the following for JDBC driver class and JDBC URL format. Manual JDBC Information