Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SSRS lock users		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

stevek

Australia
22 Posts
Posted - 03/05/2014 :  01:17:33  Show Profile  Reply with Quote
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.

admin

1637 Posts
Posted - 03/05/2014 :  03:54:16  Show Profile  Reply with Quote
Please go to Admin > Users and update the Windows Password for the users that are accessing the SSRS report.
Go to Top of Page

stevek

Australia
22 Posts
Posted - 03/05/2014 :  04:15:51  Show Profile  Reply with Quote
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.
Go to Top of Page

admin

1637 Posts
Posted - 03/05/2014 :  05:17:07  Show Profile  Reply with Quote
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
Go to Top of Page

stevek

Australia
22 Posts
Posted - 03/09/2014 :  22:09:35  Show Profile  Reply with Quote
Thanks. That worked a treat.

Just used the

update AppUser set NtPassword = null

As I wanted to keep the user list.
Go to Top of Page

stevek

Australia
22 Posts
Posted - 03/16/2014 :  16:30:22  Show Profile  Reply with Quote
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
Edited by - stevek on 03/16/2014 16:30:53
Go to Top of Page

admin

1637 Posts
Posted - 03/16/2014 :  21:11:58  Show Profile  Reply with Quote
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")))%>";
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page