How to use Microsoft Authentication to execute MS SQL Blueprints

Products

• CA Configuration Automation
• CENDURA

Issue/Introduction

The customer doesn't want to use SQL Authentication to connect to SQL Server via
Blueprints due to security concerns.
There is any way to change from SQL to MS authentication?

Environment

Configuration Automation r12.9

Resolution

Below are the steps required to follow for windows authentication in SQL Server Blueprint.

1. Need to have a windows user created in the Local Users and Groups
2. Create login for the windows user in the SQL Server.
    a. Login name should be like domain-name\username . ex:CCA-EWS2016\test
b. In Server Roles tick the "public" checkbox
c. In User Mapping map the required database against to the new windows user
d. db_owner,public database role should be enabled for Database
3. Provide user name as domain-name\username . ex:CCA-EWS2016\test and password in the sql server blueprint
4. Now refresh the blueprint to fetch the data.