25 Apr 2018

SQL Server Reporting issue -- What to look at first glance

We had a issue with our reports since  users were not able to access the reports.

We checked the reporting log files and got the actual issue .

Connect to your Report server and explore the path & open the latest report log file


C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles


Error:

Logon attempt for user 'svc_ssrs_report' failed., Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed.
Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception:
The referenced account is currently locked out and may not be logged on to
at Microsoft.ReportingServices.Diagnostics.Utilities.LoginUtil.Login(String userName, IntPtr ptrPwd, String domain)

Resolution:

Reporting user was unlocked by Windows team and account policies were changed so it never locked-out again.


banner
Previous Post
Next Post

0 comments: