Logon failed(rsLogonFailed) Logon failure:account currently disabled
I have come across this error message in ssrs and cannot seem to locate the error. Report manager lets me logon-- I can navigate to the folder but once I click on the actual report I get this error
and suggestions as to why and how to fix it???
Thanks in advance
November 16th, 2006 8:00pm
It looks like your Report Server credentials are correct, but the credentials to access the data source for the report are not. You will need to fix the disabledcredentials used to access the data for the report.
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2006 11:53pm
You need to make sure that you assign the same ID/passwords to the "EXECUTION ACCOUNT" under "Reporting Services Configuration manager. Once you do that you should be able to run your reports.
Murad
June 6th, 2007 11:35pm
Make sure the user name (under Credentials stored securely in the report server) for the Data Sourceis not locked!!
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2007 10:11pm
Due tovery stringent security at our company we have our SQL domain service account (which runs SQL and Reporting Services and more importantly the Reporting Services Execution) set to deny log on local rights on the server, even though this account has log on as a service rights.Unfortunately the service account must have log on local rights to execute a report. Therefore after we removed the deny log on local setting for this account the report ran without this error.
February 5th, 2009 7:51pm
That's what I needed. Thanks for the help.
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2011 5:32pm