Using the SQL Server Connection Type

How to use the SQL Server connection type

The SQL Server connection type allows your form application to securely connect and interact with a Microsoft SQL Server database. A SQL Server database is a structured collection of data within a Microsoft SQL Server instance. These databases are widely used in enterprise environments to manage large volumes of structured data, support business applications, and ensure data integrity and security.

Using a SQL Server connection reduces manual data entry and keeps your systems in sync. All connection settings, including credentials and connection strings, are encrypted when saved.

1. From the Configuration menu on the left, select Data Connections.
2. Click + 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. These credentials must allow read and/or write access, depending on what your form needs to do (retrieve data, submit data, or both).
   Important: Always follow your organization’s security practices when handling database credentials.
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.