SQL Server Native Client connection string does not save password

[Sonja_Bauernfeind]

Username and password is prompted every time a reload is triggered regardless if “Allow saving password" was checked during the data link connection process. 
 

Please note this is not a QlikView issue, but database and driver issue as described in the Microsoft bug specified in this link: Data-Link Dialog does not allow SQL Authenication.

Environment: 

QlikView  

Resolution:

There are two workarounds for this issue.

1. Use Microsoft OLE DB Provider for SQL Server instead of SQL Server Native Client
   
   
   
   
2. Modify manually the connection string generated using SQL Server Native Client as follows:
   1. Create a connection using Microsoft OLE DB Provider for SQL server.
   2. At the end of the connection string copy the Xpassword option into a notepad or clipboard.
      
   3. Create a connection using SQL Server Native Client
   4. Search and remove the following string:
      Integrated Security=""
   5. At the end of the connection string add password credentials from the previous copy.