Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
azmeerrehan
Partner - Creator
Partner - Creator

Reload Keeps asking for Service Account Password

I have the Below connection to Access DB

OLEDB CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source= MY_Database;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False];

Using QV 12, Win Server 2016

When I trigger the reload its asking for the Service account password. So If I try to run it from QMC it fails. BUt if Run the same job on the server QV desktop it runs after entering the password. How can I disable the password prompt.

 

 

1 Solution

Accepted Solutions
azmeerrehan
Partner - Creator
Partner - Creator
Author

Resolved, needed to add the URL for the access database to  the Trusted sites in IE

View solution in original post

1 Reply
azmeerrehan
Partner - Creator
Partner - Creator
Author

Resolved, needed to add the URL for the access database to  the Trusted sites in IE