How to Configure a Microsoft SQL Server Connection

Available in the Enterprise edition only.
The steps for configuring a connection to a Microsoft SQL Server server are the following:
  1. Go to menu Preferences > Data Sources.
  2. In the Connections panel click the New button.

    The dialog for configuring a database connection will be displayed.

    The Connection Configuration Dialog

  3. Enter a unique name for the connection.
  4. Select a SQL Server data source in the Data Source combo box.
  5. Fill-in the connection details.
    1. Fill-in the URL of the SQL Server server. If you want to connect to the server using Windows integrated authentication you must add ;integratedSecurity=true to the and of the URL, so the URL will look like:
      jdbc:sqlserver://localhost:1433;databaseName=test;integratedSecurity=true
    2. Fill-in the user name for the connection to the SQL Server.
    3. Fill-in the password for the connection to the SQL Server.
  6. Click the OK button to finish the configuration of the database connection.