Hello Techies,
We need to connect to a custom SQL database from DeltaV Live.
DeltaV Live Administration allows to configure the SQL Connection object with below attributes:1. ServerName2. DatabaseName3. ConnectionType (Trusted/Non-Trusted) 4. UserName5. Password
We have been working great with the above attributes where UserName configured as DeltaVAdmin & Connection Type as Trusted. The DeltaV user having assigned with the ADMIN role at DeltaV and Windows can connect with the SQL database.
With the DeltaV station on thin client, the Windows user is different than DeltaV User. How can we connect to the SQL Server using current DeltaV user?Need to do the code using TypeScript for a contextual display in DeltaV Live.
Let me know in case need further details.
Thanks in advance!