[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1147
  • Last Modified:

SSRS Report Builder prompt for login

I am running SSRS for MSSQL 2008 with an external URL.  When a user logging in from a computer outside of the domain pulls up the Report Manager interface, they are prompted to login.  They are able to use their domain credentials and see the reports they have been granted access to.  The problem is that when they open Report Builder, the user is not prompted for their login again and Report Builder assumes the credentials of the user that they used to log in to their computer and not the domain user supplied to Report Manager.  I have been unable to figure out how to force Report Builder to prompt for login credentials.  Is this possible?  If so, how would I go about doing this?
1 Solution
If you are giving them access via Active Directory which is what I am getting from your post, then what is happening is normal.

THis assumes that I understood your question correctly.

If don't want the user's domain account to NOT be impersonated by the report, then use SQL Server to create user accounts OR use Basic windows authentication.

This way, the user logs into your domain with Active Directory account but are prompted for Reports login.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now