Is there a way to configure FDM connecting string for establishing connection to SQL server (which is possible only via Windows Authentication) using NPA account

book

Article ID: 209983

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I do understand there are workarounds to make FDM use windows authentication by placing the file "sqljdbc_auth.dll" at specific location. But here in my case I want to access SQL Server (which allows only windows authentication) with our Non Personal Account instead of Windows logon credentials.

Can you help us achieving the same ?

Environment

Release : 4.9

Component : TDM ACTION SERVICE

Resolution

 For FDM, there is no option of using non-personal account usar as windows authentication. When you enable windows authentication in FDM, it uses logged in user credentials for authentication and connect to the server.