I cannot authenticate user in SSMS for linked server (snowflake)

Viewed 133

Similar problem to one reported here: Can't create linked server to Snowflake

Difference is while connecting to snowflake I cannot authenticate user in the SSMS:

enter image description here

ODBC driver must be verified by external browser (no password) but it is not happening here. Internet browser in SSMS is working fine, but it is not used to authenticate ODBC user. Configuration of ODBC is fine, as it is working in PowerBI and starting authentication process in default internet browser. Any ideas?

1 Answers

ODBC driver must be verified by external browser

Linked server connections run in the SQL Server process, so there's no interactive access to the desktop to do any kind of interactive authentication.

Related