Forum Discussion
Helper IPrompt all users to enter AD credentials when accessing PBIRS reports
Yes, kiosk PCs are a slightly different use case. If you want EVERYONE that connects to PBIRS to be prompted then you could switch from using Windows auth to using Basic auth (see https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver15 ) Note: you should make sure you have HTTPS configured when using basic auth as the credentials are sent in clear text as part of the request.
The only issue then is that there is no "logout" button in the report portal, so the only way to "logout" is to close ALL browser windows. Closing just the current tab is not enough.
Super User
Abdelmajid wrote:
The reason for this decision is that we have multiple associates from different levels sharing the same PC, and we need to prompt everyone
I don't think you should be trying to fix this at the PBIRS level. I think you should just get your associates to log out from windows when they finished with the shared PC's. That way when they want to access a report they log in to windows then just access PBIRS and the normal windows auth works. Then when they have finished they log out (they can leave the PC switch on to save the next person from having to boot up).
That way everything they do on that PC is done using their login. So if you have any security or other issues you can directly trace this back to a specific user.
Helper IThanks. Our case is a little different. We have many shared PCs at the stores and they are always ON using a generic kiosk account.
if users try to access the PBIRS url in the current scenario, the accesss uses the generic Kiosk as the login account to authenticate.
Since PBIRS is using the default Windows authentication and picking up the user from the machine, we have to somehow force the PBIRS url to ignore the PC credentials and just force every user to enter credentials when when getting the prompt box.
have done some research and seems doable using IIS, just don't have the proper documented steps for that.
- d_gosbell
Yes, kiosk PCs are a slightly different use case. If you want EVERYONE that connects to PBIRS to be prompted then you could switch from using Windows auth to using Basic auth (see https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver15 ) Note: you should make sure you have HTTPS configured when using basic auth as the credentials are sent in clear text as part of the request.
The only issue then is that there is no "logout" button in the report portal, so the only way to "logout" is to close ALL browser windows. Closing just the current tab is not enough.
FarhanAhmedCommunity Champion
In your case, you may also consider creating a browser shortcut for every user which will be running as "RunAs"
runas /user:abc.xyz "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"