Prevent SSRS from opening multple authentication windows

37 Views Asked by At

Setup SSRS 2017 32bit ODBC driver for Snowflake I am able to connect and retrieve my data but, the drive must be set to Authenticator: externalbrowser. This is annoying because it pops up a window for each dataset when it runs. There could easily be a report with 10+ datasets resulting in 10 browser windows, is there anyway to silence the authentication? or reduce it to 1 per report

1

There are 1 best solutions below

1
Dave Welden On

You may want to try Using Connection Caching to Minimize the Number of Prompts for Authentication. We had the same issue when connecting to Snowflake using Excel. This account level parameter change resolved our issue.