SQL Server Communication

Use a secured database connection to secure the communications between the instance database server and the Archer web and services servers. For recommendations on configuring a secure database connection, see the Microsoft MSDN Library.

The Configuration database accepts secure or encrypted connections. It is recommended that you follow the guidance in SSL Certificate Guidance when issuing an SSL certificate to communicate with SQL Server.

Use encryption (Optional) 

Select the Use Encryption option in the Archer Control Panel to encrypt communication between the Archer servers and SQL Server.

Note: If you deactivate the Use Encryption option in the Archer Control Panel, but if Force Encryption is activated on SQL Server, then SQL Server will not accept the unencrypted data.

Force encryption (Optional) 

Configure the Force Encryption option in SQL Server to only accept encrypted data sent from the Archer servers to SQL Server. For more information, see the Microsoft SQL documentation.

After configuring the encryption, restart the services and reset IIS on the Archer Web Servers. Verify that there is an encrypted connection between SQL Server and the Archer servers.