Adding a SQL connection profile for an MS SQL Server database

To add a SQL connection profile:

  1. Click Add Connection Profile in the Connections view.
  2. Type a unique name in the Name field.
  3. Select the Microsoft SQL Server JDBC Driver(DataDirect) from the driver selection list. You can click New Driver if you need to configure a driver. In most cases, however, the correct driver is installed and configured automatically during installation of DB Navigator. SQL can have multiple JDBC connections. Notice that the format for the selected driver's URL appears in the URL field. If necessary, you can edit the text in the URL field to include the appropriate information for your system.
  4. To edit a URL:
    1. Deselect the Specify URL Details checkbox (by default, this checkbox is selected, preventing you from editing the URL field).
    2. Supply a hostname (use localhost if the host is local to the system). If you are using an IPv6 address, insert a bracket before and after the address; for example, [thehostmachine].
    3. Type the port number.
    4. Type the database name.
    Note: Since the format of the URL and the required information can vary from driver to driver, see the documentation for your driver if you need more information.
  5. Type the user name and, optionally, a password.
    Note: You must specify the user ID when creating a SQL connection.
  6. Choose Open on Eclipse startup if you want the connection to open when Eclipse starts (provided the database server is already started). Note that you still must enter a valid user ID (and optionally a password). Also, be aware that this option slows the startup of Eclipse.
  7. Choose Auto-Login on connect to automatically log into the database when connecting.
  8. Type the name of the Host.
  9. Type the correct value in the Port field.
  10. Type the name of the database in the Database field.
  11. Add any additional JDBC connection properties in the Additional parameters field, delimited by semicolons in the format key1=value; key2=value. (Refer to the documentation for your JDBC driver for a list of supported parameters.)
  12. Click Test Connection. If the connection succeeds, a Connection succeeded message appears. If the connection does not succeed, an error message appears.
  13. Click OK.
Related Tasks
Troubleshooting the MS SQL Server JDBC driver
Preliminary Draft
© 2017 Progress Software Corporation and/or one of its subsidiaries or affiliates. All rights reserved.