Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

encryption/hashing of clear text password for SQL Server?

I need help with encryption/hashing of clear text password for SQL Server, without manually creating through connect string through the "Data Link Properties" dialog.

e.g. replace

OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (Password is pass);

with

OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (XPassword is AIceIYFMTbcOL);

How can I get "AIceIYFMTbcOL" for "pass" without going through the creation of connection string in QV & then copying it to configuration file process; for each User ID/Initial Catalog/Data Source/Password combination.

Thanks,

Prashant

1 Reply
bumin
Partner - Creator II
Partner - Creator II

Hi Prashant,

the connect stringt with password is like follows

Provider=SQLOLEDB.1;Password=yourpassword;Persist Security Info=True;User ID=sa;Initial Catalog=coda;Data Source=localhost;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SRVQV;Use Encryption for Data=False;Tag with column collation when possible=False

regards

Bumin