Edge vs IE and SSRS Authentication

Question

Running a non-Domain connected PC, Windows 10 and SQL Server 2016 Reporting Services Configuration Manager.

Opening reports in IE works just fine, but when I attempt to open the reports in Edge it continues to ask for a username and password. Typing in the username and password the report displays properly, but I just want it to automatically login. I've tried adding the site to trusted sites, to local intranet sites, I updated the custom level to auto login. I've tried looking for edge to run in IE compatibility mode, but can't find that option anywhere. I've tried updating rsreportserver file authentication from NTLM to Negotiate.

Answer 1

Hi @Josh Davis
There are actually two logins you deal with when it comes to reporting services.

The login to the database is to capture the data, it has nothing to do with the actual report itself. That login you used is sent to the database as the user / credentials being used to pull the report data.

This prompt you have a screen shot of, is the authentication to the report server, by default rs uses windows authentication so enter your domain\username with password.

If you do not like this default behavior you can change it, this guide should get you started: http://msdn.microsoft.com/en-us/library/cc281253.aspx

For details infomation ,please refer to :https://stackoverflow.com/questions/12166202/reporting-services-ssrs-prompts-with-username-password

Best Regards,
Isabella

Answer 2

The solution is to not use the Microsoft Edge that comes with Windows 10, you need to go online and download another version of windows edge. Once that is done you can open reports in this edge using normal updates you would do in internet explorer