| T O P I C R E V I E W |
| stevek |
Posted - 03/05/2014 : 01:17:33
Hi all,
We are having an issue with Version 183.
The users can open a couple of SSRS reports through Report Portal then they are being ask for Windows Credentials.
The Users Windows Account is then locked.
Then in Report Portal --> Admin --> Connections
DB connection
I tested the connection and received the following Message.
The referenced account is currently locked out and may not be logged on to.
This account was not locked out prior to reporting the reports
Any help would be greatly appreciated.
|
| 6 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 03/16/2014 : 21:11:58
When the Windows Password is blank the SSRS report will still try to pass the Windows credential without the password. Please find and open rs\userInfo.aspx in notepad and change line 3 from:
var sNtSecInfo = "<%=Encode64(Session("NtUserId") + ":" + Session("NtPassword"))%>";
to:
var sNtSecInfo = "<%=IIF(Session("NtPassword")="","",Encode64(Session("NtUserId") + ":" + Session("NtPassword")))%>"; |
| stevek |
Posted - 03/16/2014 : 16:30:22
Jumped too quick to success unfortunately.
Whilst we are not receiving as many complaints we are still getting lockouts on our frequent users using SSRS reports..
Only when using SSRS through Report Portal.
still lockouts after
1. Tried restarting the IE browser-
2. Tried using different Browsers Firefox, Chrome and IE.
Reset the lockout and away they go again. Can be a number of days later.
Not near mandatory password changes
Works fine if they go direct to the Reporting Server (SSRS)
Somewhat baffled.
We are going back to the installation process of both products but not finding anything out of the normal.
If you have any further suggestions it would be very much appreciated.
Thanks you
|
| stevek |
Posted - 03/09/2014 : 22:09:35
Thanks. That worked a treat.
Just used the
update AppUser set NtPassword = null
As I wanted to keep the user list.
|
| admin |
Posted - 03/05/2014 : 05:17:07
You can try to reset windows credentials for all users by running this SQL for ReportPortal database in SQL Server Management Studio:
update AppUser set NtUserId = null, NtPassword = null
|
| stevek |
Posted - 03/05/2014 : 04:15:51
Thanks for the quick response.
If we use the ssrs server direct we don't have any issues.
This issue is only happening through Report Portal.
We are upgrading from a previous versions and having large number of users.
Can you suggest a quick way to do this. |
| admin |
Posted - 03/05/2014 : 03:54:16
Please go to Admin > Users and update the Windows Password for the users that are accessing the SSRS report. |
Report Portal
