Securing a Database Connection Between MSSQL and Magic xpa (Magic xpa 4.x)

Objective

How to secure the database connection between an SQL database and Magic xpa (using SSL).

Solution

Magic xpa communicates with the MSSQL client. The secure connection is between the MSSQL client and the MSSQL server. Therefore, you should configure the server and the client to use a secure connection and it should then work from Magic xpa.

Here you can find details about how to configure the secure connection between the client and the server:

http://msdn.microsoft.com/en-us/library/ms189067(v=sql.105).aspx