Microsoft SQL JDBC Driver

ReadyAPI has preconfigured connection strings for MSSQL. If you need a custom one, add it by using the ReadyAPI Preferences menu.

1. Click Preferences on the toolbar.

2. Open the JDBC Drivers settings.

3. Click .

4. Enter a descriptive name for the driver.

   

   Use the following name for now: MSSQL(MS)/com.microsoft.sqlserver.jdbc.SQLServerDriver.

   The new connection will appear at the end of the list.

   

   Click the image to enlarge it.

5. Add a connection string template.

   The connection string syntax may vary depending on whether you use an unnamed or named instance:

   • For server port – 
     jdbc:sqlserver://<HOST>:<PORT:1433>;databaseName=<DB>;

   • For named instance – 
     jdbc:sqlserver://<HOST>;instanceName=instanceName;databaseName=<DB>;

     Important notes

     Important notesImportant notes

     • Replace instanceName with the actual name of your instance.

     • Make sure the SQL Server Browser service is running. Otherwise, ReadyAPI will not be able to find the database. To run the service:

       1. Run SQL Server Configuration Manager.

       2. Select SQL Server Services in the navigation tree.

       3. Right-click SQL Server Browser and select Start.

   

   Click the image to enlarge it.

1. To use Windows (NTLM) authorization with JTDS, open the sqljdbc_6.0\enu\auth\ folder of the extracted driver archive. Depending on the bitness of your operating system, open to the x86 or x64 folder, copy the sqljdbc_auth.dll file, and place it in the <ReadyAPI>/bin folder of your ReadyAPI installation.

   If ReadyAPI is running, you need to restart it.

2. Add the integratedSecurity=true; parameter to your connection string. To do that:

   1. Open the Databases dialog.

   2. Double-click the Connection string column next to the needed connection.

   3. Add the parameter to the connection string.

   4. Press Enter to finish editing.

   The connection string will look like this:

   jdbc:sqlserver://localhost:1433;databaseName=myDB;integratedSecurity=true;