I am getting an error when the Reload Task runs (automatically) in the Publisher.
Seeing the log I can read the following message:
"Login failed for user ''. The user user is not associated with a trusted sql server connection"
I am on a 64-bit server using OLEDB Connect with Windows Authentication and in the computer where I develop (QlikView Desktop) I am able to connect to the database (making it possible to construct the connection string) but in the server I can not (with the same user and the server can see the database)...
The windows account used for the Qlikview Distribution Service is not defined to your SQL Server. If you already tried putting a userid/pwd in the connection string, it looks like it's being ignored because your SQL Server is setup to use Windows Authentication only.
What happened was that the password of the user that runs the services was changed in windows but wasn't changed in the services so they were running with the old password.
I dunno why the others reload work and only the one created after the password changed didn't but with the new password and with a restart, i was able to access to the database (meanwhile it was even giving me another error: "Cannot generate SSPI context").