Problem with OLEDB connection string to connect to SQL Server database

[#1]

Hi

I use OLEDB connection to connect to my SQL database but sometimes the related connection string contains an extra part at the end of it (First example) and sometimes it does not contain this part. Does anyone know how I can have the first example, because when I give Qlikview exe file to users they have to enter password everytime they reload the data.

First Example : OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=**;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is HNUNFYEHGTRNETYYA);

Second Example : OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security="";Persist Security Info=False;User ID=***;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False;DataTypeCompatibility=0;Trust Server Certificate=False];

Thanks

Farzaneh

[ashfaq_haseeb · Accepted solution]

Hi,

While creating your connection string make sure to select Allow saving password.

As shown in the attached image.

Regards

ASHFAQ