How to switch from Microsoft SQL Server Authentication to Windows/Integrated Authentication

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

If you decide to switch from SQL Server authentication for the data_engine to Windows/Integrated authentication, there are certain changes which need to be made for it to work.

Environment

• Release: UIM 20.4 or higher
• Component: CAUIM

Cause

• Guidance

Resolution

On the Primary Hub

1. Change Nimsoft Robot Watcher service's Log on to the Windows/domain user
2. Restart the 'Nimsoft Robot Watcher service'
3. Open data_engine probe and add "Integrated Security=SSPI" to the Parameters, so it will look like the following:
   
        Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI
4. Restart data_engine probe
5. Verify from the logs and the Status section of the probe that the data_engine is connected to the database and working correctly

On the OC Server

1. Change Nimsoft Robot Watcher service's 'Log on' to the Windows/domain user
2. Restart Nimsoft Robot Watcher service
3. Verify wasp probe is up and running