topic when i reload SQL data it alway ask me enter SQL password ? in QlikView https://community.qlik.com/t5/QlikView/when-i-reload-SQL-data-it-alway-ask-me-enter-SQL-password/m-p/764636#M666265 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am trying to reload a SQL data into QV , when i press control R. it will pop up a new windows ask me input password of SQL Server login.</P><P></P><P>My load script as below :-</P><P></P><P>CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];</P><P></P><P>select * from record_produksi_plc;</P><P></P><P>where i can add the script for the password = 1 ? so that it will not ask me again .</P><P></P><P>Paul</P></BODY></HTML> Tue, 18 Nov 2014 03:38:15 GMT paulyeo11 2014-11-18T03:38:15Z when i reload SQL data it alway ask me enter SQL password ? https://community.qlik.com/t5/QlikView/when-i-reload-SQL-data-it-alway-ask-me-enter-SQL-password/m-p/764636#M666265 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am trying to reload a SQL data into QV , when i press control R. it will pop up a new windows ask me input password of SQL Server login.</P><P></P><P>My load script as below :-</P><P></P><P>CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];</P><P></P><P>select * from record_produksi_plc;</P><P></P><P>where i can add the script for the password = 1 ? so that it will not ask me again .</P><P></P><P>Paul</P></BODY></HTML> Tue, 18 Nov 2014 03:38:15 GMT https://community.qlik.com/t5/QlikView/when-i-reload-SQL-data-it-alway-ask-me-enter-SQL-password/m-p/764636#M666265 paulyeo11 2014-11-18T03:38:15Z