SQL Server Settings

Global SQL Server Connection String

🚧

SQL Server connections are secure by default, which means that encryption is expected to be enabled for these connections.

Enter the remaining Connection Attributes as a semi colon delimited string containing whatever settings are required, for example: Server=myserverlocation;Initial Catalog=MyCatalog;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;

1. Set the user id and password for the connection string.
2. (Optional) For multiple accounts:
   1. Click the New Set button to create additional accounts. For example, Sandbox and Production.
   2. Click the Set as Default button to change the default connector set. If the previous Default was set in Design, SmartIQ will use the new Default values.