Use Credential Manager to host SQL authentication

Question

Hi, 
 Now InTouch embedd credential manger. 
 It is possible to store a SQL Login/Pwd and reuse it to connect to a SQL database through scripting ? 
 I'm not speaking about connecting an user or passing SQL to AlarmClient/Trend. 
 The goal is to execute a SQL query without using clear text password. 
 Thanks

Richard Köhlerstrand · Accepted Answer

Hi Mathieu! Some months back I was asking Aveva about this, unfortunately I was not able to find a working solution, so I'm very interested in engaging in this discussion. We have several customers that wants to move away from SQL Server login credentials, and use dedicated SQL AD accounts instead. But the connection string used to connect and execute a query/stored procedure will involve using username / password in clear text in script or storing this in CustomProperties/Object Attributes witch is not ideal. 
 Only way around this is to use integrated security but this will use the Windows account starting InTouch, but that will not allow for separating logged in user that starts InTouch and the user connecting to SQL. 
 I was exploring the possibility to create a custom DLL for storing credentials (encrypted), but did not reach a conclusion on what would be the best "future proof" solution. 
 The Credential Manager seems to be the best viable option if it was possible to call upon it in a scenario as you describe.

Use Credential Manager to host SQL authentication

Top Replies