Available in the Enterprise edition only.
The steps for configuring a connection to a Microsoft SQL Server server are the
following:
-
Go to menu .
-
In the Connections panel click the New
button.
The dialog for configuring a database connection will be displayed.
The Connection Configuration Dialog
-
Enter a unique name for the connection.
-
Select a SQL Server data source in the Data Source combo
box.
-
Fill-in the connection details.
-
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
-
Fill-in the user name for the connection to the SQL Server.
-
Fill-in the password for the connection to the SQL Server.
-
Click the OK button to finish the configuration of the database
connection.