Microsoft SQL Server Connector > Connections for Microsoft SQL Server > Configure SSL with the serverless runtime environment
  

Configure SSL with the serverless runtime environment

You can use the serverless runtime environment with Microsoft SQL Server Connector to connect to an SSL-enabled Microsoft SQL Server database.
Before you configure a secure Microsoft SQL Server connection using the serverless runtime environment, complete the following prerequisite tasks to add the SSL certificates to the serverless runtime location:
  1. 1Create the following structure for the serverless agent configuration in AWS or Azure: <Supplementary file location>/serverless_agent_config
  2. 2Add the truststore certificate in the Amazon S3 bucket or Azure container in the following location in your AWS or Azure account: <Supplementary file location>/serverless_agent_config/SSL
  3. 3Copy the following code snippet to a text editor:
    4. version: 1
    agent:
    agentAutoApply:
    general:
    sslStore:
    - fileCopy:
    sourcePath: SSL/<TrustStore_filename>

    where the source path is the directory path of the certificate file in AWS or Azure.
  4. 4Ensure that the syntax and indentations are valid, and then save the file as serverlessUserAgentConfig.yml in the following AWS or Azure location: <Supplementary file location>/serverless_agent_config
    5. When the .yml file runs, the SSL certificate is copied from the AWS or Azure location to the serverless agent directory.
  5. 5In the Microsoft SQL Server connection properties, specify the following certificate path in the serverless agent directory in the Trust Store field: /home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<cert_filename>