question

nandakishore-3133 avatar image
1 Vote"
nandakishore-3133 asked vkishore440-8074 commented

SSRS 2019 Https Web Portal URL asking username and password on all activities like open/drilldown(On Click)

Installed SQL Server 2019, SSRS 15.0 Version. Deployed Reports to https URL with certificate. I could deploy and access reports in local (Requested credentials at login - only once). But when I'm accessing the reports outside VM to Https URL, It is asking for credentials on login, After accessing any report, sometimes in middle of something.
Tried it in various browsers, same issue for all.
Even If I enter credentials, it will ask for 4 to 5 times continuously. After that it will not ask until I access another folder.



64222-image.png


sql-server-generalsql-server-reporting-services
image.png (30.7 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Kishore,

is this issue resolved ? i am also facing same issue in SSRS. if it is resolved please guide me how to resolve it.


Thanks
Kishore.

0 Votes 0 ·

Hi Kishore,

is this issue resolved ? i am also facing same issue in SSRS. if it is resolved please guide me how to resolve it.


Thanks
Kishore.

0 Votes 0 ·

Are you using Firefox as the OP?
By default Firefox don't support Windows pass through authentication, as Internet Explorer and Edge do.

1 Vote 1 ·

Hi @OlafHelper-2800,

Thanks for your reply,

i am using Google chrome, IE and Microsoft Edge.

Thanks
Kishore

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered nandakishore-3133 commented

Hi @nandakishore-3133,

Please try this:

  1. Open Internet Explorer

  2. Go to Tools and click on Internet Options

  3. Under the Security tab, click on Trusted sites and click the Sites button and Add Report Manager/Report Server URL to the trusted sites.

  4. Then click Custom Level, and check the option Automatic logon with current user name and password

  5. Access the url for a try

64432-screenshot-2021-02-05-140213.jpg


If this doesn't help, please help check if you are using Kerberos authentication.

To deal with this issue, please try to remove RSWindowsNegotiate and ensure RSWindowsNTLM is specified in the rsreportserver.config file.

Or you may follow this to implement Kerberos Delegation with SSRS.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the reply.
Already tried above methods, Still getting that issue.

Tried Automatic logon with same user and password.

Kept these values in Authentication in rsreportserver.config file -

<Authentication>
<AuthenticationTypes>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>

Additional info:
Report Server Mode: Native
Built-in Account: Network Service

0 Votes 0 ·