Forum Discussion

Doug_Pruiett_24's avatar
Doug_Pruiett_24
Icon for Nimbostratus rankNimbostratus
Feb 08, 2016

Multiple Windows Authentication Prompts after F5 Authentication

I am not the principle engineer on this issue, nor an F5 expert. I am part of a project that uses F5 and doing a little research to see if I can find help for an issue we are having.

 

The desired scenario as I understand it is as follows:

 

  1. We send by email a SQL Server Reporting Services (SSrS) report to a recipient.
  2. In the email message body are hyperlinks that when clicked are supposed to route the user through our F5 onto the SSrS report manager, where a report is then run and displayed.
  3. The user clicks the hyperlink in the email and is prompted by F5 for their domain credentials.
  4. F5 routes them to the SSrS report manager site where the selected report is run and displayed.
  5. The report that is displayed also has within it hyperlinks that open another report on the SSrS report manager.
  6. The user clicks on one of these hyperlinks and the third report runs and displays.

Here is the problem we are having:

 

  1. When the SSrS report manager was running on a single server, the user was prompted once by F5, routed to the report on the report manager, and the report ran and displayed. If the use clicked on a hyperlink in this second report, the third report ran and displayed. The user was only prompted for authentication credentials once (by F5) in this process.
  2. When the SSrS report manager is load-balanced on two servers, the user gets prompted for credentials by F5, then by Windows. If the user is on a domain-joined computer in the network, then he receives no further prompts as he moves from the second report to the third report. However, if the user is on a non-domain computer outside our network, when he clicks on a hyperlink in the second report, he is prompted again for Windows credentials (a variable number of times from once to five times or more). Sometimes the third report will come up if we cancel the authentication dialogue, other times not.

Can anyone suggest what might be causing this phenomenon and what we might do to fix it? Thanks for any help.

 

12 Replies