Redpoint Interaction v7.x Documentation
Redpoint Interaction v7.x Documentation
Breadcrumbs

Admin: SQL Server configuration

This section describes how to configure a SQL Server connection for a specific Redpoint Interaction tenant running within a container application. Please follow the steps below:

  1. In the Configuration Editor’s Data Warehouse Settings section, select the SQL Server provider.

  2. Enter the required parameters such as Server, Database Name, Username, and Password.

image-20241211-094827.png

  1. Specify optional parameters (e.g., per the SQL Server Settings section if required).

  2. Copy the JSON text template to provision the new tenant.

image-20241211-095031.png

  1. Once the tenant has been provisioned, a sample connection string is generated.

Server=localhost;Database=AdventureWorks;UID=sa;PWD=******;
Encrypt=True;TrustServerCertificate=True;ConnectRetryCount=3;ConnectRetryInterval=10

  1. For more information about SQL Server connection string parameters, please see https://learn.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlconnection.connectionstring?view=sqlclient-dotnet-standard-5.2.