HomeGuidesAPILog In

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 KeyDescription
ServerSpecifies the server/database name
Initial CatalogThe SQL database name
Persist Security InfoIt is recommended to set this to False when the user ID and password are included in the connection string
EncryptEncrypts SQL server data connections/actions. By default, this is set to ‘true’.
TrustServerCertificateSet to ‘true’ if the SSL Provider connection mentions the authority or certificate name.
Connection TimeoutSeconds 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