https://community.qlik.com/t5/Official-Support-Articles/Issue-with-quot-XPassword-quot-and-OLE-DB-SQL-Server-Native/ta-p/1712810 <P><BR />The SQL Server Native 11 Client Driver does not store the encrypted password correctly in the Connection String. This is causing errors with the Connection.</P> <P><SPAN style="font-family: inherit;">In order to reproduce the error, the following steps are followed:</SPAN></P> <OL> <LI>Log into a Server with SQL Server 2012 Native Client installed and QlikView with a user that does not have Windows Authentication to the Database Connection.</LI> <LI>Open a Blank QVW and Edit the Script with the OLE DB Connection</LI> <LI>Choose the SQL Server Native Client 11.0 in the Data Link Properties Provider tab&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043a.png" style="width: 367px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54546iAF4D449702381512/image-size/large?v=v2&amp;px=999" role="button" title="000049043a.png" alt="000049043a.png" /></span> <P>&nbsp;</P> </LI> <LI>Fill out the Connection Properties for a SQL Server Authorized User and Click "Test Connection" Everything should succeed at this point.&nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043b.png" style="width: 233px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54545i68339768D5D09717/image-size/large?v=v2&amp;px=999" role="button" title="000049043b.png" alt="000049043b.png" /></span> <P>&nbsp;</P> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</LI> <LI>However, once you click OK the following error is shown, "<FONT face="courier new,courier">Connector connect error: ErrorSource: Microsoft SQL Server Native Client 11.0 ErrorMsg: Login failed for user.</FONT></LI> </OL> <H3><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043c.png" style="width: 741px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54544iF54A7FC38D403548/image-size/large?v=v2&amp;px=999" role="button" title="000049043c.png" alt="000049043c.png" /></span></H3> <P>&nbsp;</P> <H3>Environment:</H3> <P><LI-PRODUCT title="QlikView" id="qlikView"></LI-PRODUCT>,&nbsp;12.20 and newer</P> <H3 class="qlik-migrated-tkb-headings">&nbsp;</H3> <H3 class="qlik-migrated-tkb-headings">Cause:</H3> <P><BR />This is caused by the SQL Server Native Client 11.0 Driver and the Connection dialog that displays after connecting to the OLE DB Driver in the QlikView Application. This is otherwise known as Integrated Security.</P> <P class="qlik-migrated-tkb-headings">&nbsp;</P> <H3 class="qlik-migrated-tkb-headings">Resolution:</H3> <P><BR />In order to bypass the error message and create a SQL Server Native Client 11.0 Connection for OLE DB the following steps need to be followed in the exact order shown:</P> <OL> <LI>Open a Blank QVW and Edit the Script with the OLE DB Connection</LI> <LI>Choose the Microsoft SQL Server Native Client 11.0&nbsp;in the Data Link Properties Provider tab&nbsp;</LI> <LI>Select the Connection Tab Enter the Server Name and User Name</LI> <LI>Deselect the Blank Password option</LI> <LI>Add the Password</LI> <LI>Select the "Allow Saving Password" option</LI> <LI>Navigate to the All tab</LI> <LI>Select the "Persist Security Info" Click Edit Value</LI> <LI>Choose "False" for the Property Value and Click OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043d.png" style="width: 411px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54543i373258677857168E/image-size/large?v=v2&amp;px=999" role="button" title="000049043d.png" alt="000049043d.png" /></span> <P>&nbsp;</P> </LI> </OL> <OL start="10"> <LI>Changing the value to "False" or using the Reset Value button will omit the Integrated Security property completely.</LI> </OL> <P>&nbsp;</P> <H3>Internal Investigation IDs:</H3> <UL> <LI><SPAN>QV-13546 </SPAN></LI> </UL> Fri, 07 May 2021 18:08:11 GMT Sonja_Bauernfeind 2021-05-07T18:08:11Z https://community.qlik.com/t5/Official-Support-Articles/Issue-with-quot-XPassword-quot-and-OLE-DB-SQL-Server-Native/ta-p/1712810 <P><BR />The SQL Server Native 11 Client Driver does not store the encrypted password correctly in the Connection String. This is causing errors with the Connection.</P> <P><SPAN style="font-family: inherit;">In order to reproduce the error, the following steps are followed:</SPAN></P> <OL> <LI>Log into a Server with SQL Server 2012 Native Client installed and QlikView with a user that does not have Windows Authentication to the Database Connection.</LI> <LI>Open a Blank QVW and Edit the Script with the OLE DB Connection</LI> <LI>Choose the SQL Server Native Client 11.0 in the Data Link Properties Provider tab&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043a.png" style="width: 367px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54546iAF4D449702381512/image-size/large?v=v2&amp;px=999" role="button" title="000049043a.png" alt="000049043a.png" /></span> <P>&nbsp;</P> </LI> <LI>Fill out the Connection Properties for a SQL Server Authorized User and Click "Test Connection" Everything should succeed at this point.&nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043b.png" style="width: 233px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54545i68339768D5D09717/image-size/large?v=v2&amp;px=999" role="button" title="000049043b.png" alt="000049043b.png" /></span> <P>&nbsp;</P> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</LI> <LI>However, once you click OK the following error is shown, "<FONT face="courier new,courier">Connector connect error: ErrorSource: Microsoft SQL Server Native Client 11.0 ErrorMsg: Login failed for user.</FONT></LI> </OL> <H3><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043c.png" style="width: 741px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54544iF54A7FC38D403548/image-size/large?v=v2&amp;px=999" role="button" title="000049043c.png" alt="000049043c.png" /></span></H3> <P>&nbsp;</P> <H3>Environment:</H3> <P><LI-PRODUCT title="QlikView" id="qlikView"></LI-PRODUCT>,&nbsp;12.20 and newer</P> <H3 class="qlik-migrated-tkb-headings">&nbsp;</H3> <H3 class="qlik-migrated-tkb-headings">Cause:</H3> <P><BR />This is caused by the SQL Server Native Client 11.0 Driver and the Connection dialog that displays after connecting to the OLE DB Driver in the QlikView Application. This is otherwise known as Integrated Security.</P> <P class="qlik-migrated-tkb-headings">&nbsp;</P> <H3 class="qlik-migrated-tkb-headings">Resolution:</H3> <P><BR />In order to bypass the error message and create a SQL Server Native Client 11.0 Connection for OLE DB the following steps need to be followed in the exact order shown:</P> <OL> <LI>Open a Blank QVW and Edit the Script with the OLE DB Connection</LI> <LI>Choose the Microsoft SQL Server Native Client 11.0&nbsp;in the Data Link Properties Provider tab&nbsp;</LI> <LI>Select the Connection Tab Enter the Server Name and User Name</LI> <LI>Deselect the Blank Password option</LI> <LI>Add the Password</LI> <LI>Select the "Allow Saving Password" option</LI> <LI>Navigate to the All tab</LI> <LI>Select the "Persist Security Info" Click Edit Value</LI> <LI>Choose "False" for the Property Value and Click OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="000049043d.png" style="width: 411px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54543i373258677857168E/image-size/large?v=v2&amp;px=999" role="button" title="000049043d.png" alt="000049043d.png" /></span> <P>&nbsp;</P> </LI> </OL> <OL start="10"> <LI>Changing the value to "False" or using the Reset Value button will omit the Integrated Security property completely.</LI> </OL> <P>&nbsp;</P> <H3>Internal Investigation IDs:</H3> <UL> <LI><SPAN>QV-13546 </SPAN></LI> </UL> Fri, 07 May 2021 18:08:11 GMT https://community.qlik.com/t5/Official-Support-Articles/Issue-with-quot-XPassword-quot-and-OLE-DB-SQL-Server-Native/ta-p/1712810 Sonja_Bauernfeind 2021-05-07T18:08:11Z