Using the SQL Server Connection Type

How to use the SQL Server connection type

The SQL Server connection type is a protocol used to establish a connection between a client application and a SQL Server database.

1. From the Configuration menu on the left, select Data Connections.
2. Click (Add Connection) to open the Connection window. 
   
3. Enter a connection name and description for the SQL Server connection. This helps you identify the data connection if you connect to more than one database.
4. Select SQL Server as the connection type.
5. Enter a username and password for the SQL Server.
6. Enter the parameters that specifies the information necessary for a client application to connect to a SQL Server database in the Connection String field.
7. Click Test Connection to ensure your settings are correct. 
8. Click Save when you've completed your changes.