Configure Symantec Management Platform to use secure communication with SQL

Products

• IT Management Suite

Issue/Introduction

 You want to configure the SQL server to use encrypted communication with Symantec Management Platform

 

Environment

ITMS 8.x

Resolution

First you need to configure the SQL to use encryption, for that follow the Microsoft article below:

How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console - http://support.microsoft.com/kb/316898 

After you have configured the SQL to use encryption, please follow the steps below to configure the Symantec Management Platform to communicate with SQL using encryption :

1. Go to <Install Drive>\Program Files\Altiris\Notification Server\Bin\Tools\ 

2. Open NSConfigurator 

3. Expand Security Settings -> DbEncryptedConnection 

4. Check the box "Enabled" 

5. Click "Save"

6. Restart all the altiris services and SQL services (on the SQL box) : 

- Altiris Client Msg Dispatcher 

- Altiris Client Task Data Loader 

- Altiris Event Engine 

- Altiris Event Receiver 

- Altiris File Receiver 

- Altiris Inventory Rule Management Service 

- Altiris Monitor Agent 

- Altiris Object Host Service 

- Altiris Service 

- Altiris Service Hoster 

- Altiris Support Service 

Now the Symantec Management Platform should communicate with SQL using encryption