Share via

"Failed to Authenticate User by External Browser" error when accessing SSRS (SQL Server Reporting Services)

satish krishnamurthy 1 Reputation point
2025-07-09T07:32:20.7866667+00:00

Trying to connect from SSRS to Snowflake via ODBC -> DSN

  1. I have setup the ODBC System DSN via EXTERNALBROWSER on SSRS report server
  2. From ReportBuilder able to connect to Snowflake via ODBC and preview the report (popup window appears for SSO password eachtime)

3)but from SSRS report server it is not working giving error :

HY000 Failed to Authenticate User by External Browser 31

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ajith G (APTLY TECHNOLOGY CORPORATION) 0 Reputation points Microsoft External Staff
    2025-07-18T08:16:07.55+00:00

    The SSRS Report Server operates as a Windows service using a service account such as NetworkService, LocalSystem, or a domain account. Since services do not have a desktop interface, browser popups cannot be displayed. As a result, while you can set up the System DSN with EXTERNALBROWSER in the ODBC admin tool, SSRS still encounters the HY000 31 error at runtime.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.