CODEWITHSUNDEEP
sql-serversnowflake-cloud-data-platformlinked-server
Ajay.k
Ajay.k

Reputation: 121

Can't create linked server from microsoft SQL to Snowflake

Created DNS and installed ODBC Drivers followed same steps from below URL https://snowflakecommunity.force.com/s/article/how-to-set-up-a-linked-server-from-sql-server-to-snowflake

Once creating testing connection at last step it shows error like OLE DB provider "MSDASQL" for linked server "SNOWFLAKEDATA" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)

But DNS created and used followed same way in URL. Can i know where I made mistake?

Upvotes: 0

Views: 1450

Answers (1)

Clement
Clement

Reputation: 194

Please ensure to create the linked server to Snowflake with the following information:

  • Provider: This should be "Microsoft OLE DB Provider for ODBC Drivers."
  • Data Source: This should match the ODBC system/user DSN name that was previously configured

enter image description here

  • Under the Security Tab on left panel, make sure to add a local login (your local machine's login including your host name) associated to a remote user (snowflake username) and its matching password.

Upvotes: 0

Related Questions