Project Results to SQL Settings
These settings are specifically for the Copy Project Results to SQL Server action.
Connection String
The connection string is required to define the SQL server connection, the key variables are semicolon deliminated. e.g. Server=myserverlocation;Initial Catalog=MyCatalog;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;
| String Key | Description |
|---|---|
| Server | Specifies the server/database name |
| Initial Catalog | The SQL database name |
| Persist Security Info | It is recommended to set this to False when the user ID and password are included in the connection string |
| MultipleActiveResultSets | |
| Encrypt | Encrypts SQL server data connections/actions. By default, this is set to ‘true’. |
| TrustServerCertificate | Set to ‘true’ if the SSL Provider connection mentions the authority or certificate name. |
| Connection Timeout | Seconds until connection timeout |
User Credentials
User Id and Password for the SQL connection
The user for the connection string must have permission to create and alter tables on the database (in addition to reading/writing data) in order to create and modify the database schema to match a project.
Multiple users can be set with the New Set option
Updated 2 months ago