Configure SQL Server

On this page

  1. Inside the cluster
  2. Custom SQL server (Azure SQL)

Inside the cluster

By default, SQL Server is deployed within the cluster. This is currently the recommended approach. However, it is possible to deploy to Azure SQL instead. When deployed inside the cluster, two secrets will get created. One will contain the password for the SQL Server (which will be a randomly generated password), the other will contain the connection strings that will be consumed by various deployments.

Custom SQL server (Azure SQL)

If you are using your own SQL installation, like Azure SQL, you will need to:

  1. Install the database definitions (DACPACs) to your SQL instance. This can be done from the command line using SqlPackage.exe.

  2. Create a secret with the connection strings for each database. The secret should have the following keys:
     apiVersion: v1
     kind: Secret
     metadata:
       name: my-connection-string-secret
     type: Opaque
     data:
       AuthenticationStore: <connection-string>
       BlobStorage: <connection-string>
       ConfigurationStore: <connection-string>
       CluedInEntities: <connection-string>
       TokenStore: <connection-string>
       Training: <connection-string>
       ExternalSearch: <connection-string>
       ML-Logging: <connection-string>
       Metrics: <connection-string>
    
  3. You should then pass the name of the secret in the values.yaml override file:
     application:
       sqlserver:
         connectionsSecretName: my-connection-string-secret