Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SCHEDULED REFRESH ERROR

I have searched for any resolutions regarding scheduled refresh errors but haven't read any.  I am getting the following:   Credentials are required to connect to the SQL source. The exception was...
RLSmart's avatar
RLSmart
Icon for Helper I rankHelper I
6 years ago

Mine are both defined the same way but still throw the error. 

 

Just for fun, I deleted the report from the pbrs server, then saved it back up there.  The Data Source 1 had no credentials saved so I set that up, but I cannot access Data Source 2 for the second query.  I assume this is the cause of the error. Even though both are set up correctly with the credentials in the desktop, it seems they are wiped out upon deploying/publishing the report to the server.  

 

Both data sources use the same database service account and connect to the same database.  The queries are sql queries, not full table imports, if that has anything to do with it.

Any other ideas?  

houston39's avatar
houston39
Icon for Helper I rankHelper I
6 years ago

Hi,

 

Have any passwords recently expired and or changed?

 

 

  • RLSmart's avatar
    RLSmart
    Icon for Helper I rankHelper I
    6 years ago

    We use database service accounts so that we don't have to worry about expirations or being tied to a person in AD that may go on leave or be terminated.  So no expirations.