ANS-0452 · WEB SERVICES & INTEGRATIONS
How to Configure Connection Strings for Azure SQL Database SSL/TLS
Ensure secure connections to Azure SQL Database by correctly configuring SSL/TLS encryption parameters in your connection string.
Short answer
To establish a secure connection to Azure SQL Database, ensure your connection string includes the parameter `Encrypt=True`. This parameter enforces SSL/TLS encryption, which is a mandatory security requirement for all Azure SQL Database connections, safeguarding data in transit.
Scenario
Users attempting to connect to an Azure SQL Database may encounter connection failures or warnings related to security protocols. This often occurs when the connection string does not explicitly specify the necessary parameters for enforcing SSL/TLS encryption, which is a fundamental security requirement for Azure SQL Database.
Solution
To ensure a successful and secure connection to Azure SQL Database, the connection string must include parameters that enforce SSL/TLS encryption. Azure SQL Database mandates the use of SSL/TLS for all connections. The recommended parameter to add to the connection string is:
Encrypt=TrueOptionally, TrustServerCertificate=False can be included to ensure the server's certificate is validated, enhancing security. This configuration ensures that all data transmitted between the client and the database is encrypted.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support