0

enter image description here

Hi, I am trying to connect Azure sql database from Access database . However its giving me the following error.

When I try with the same credential from SSMS its connects perfect however, can't connect through ODBC.

Can anyone had the same experience or anyone has any input to resolve this issue?

Thanks in advance!

jarlh
  • 42,561
  • 8
  • 45
  • 63
KRMNDev
  • 13
  • 4
  • Can you post connection setup from both ODBC Admin and SSMS (without authentication info of course) – squillman Sep 29 '21 at 16:34
  • Try once more. Sometimes Azure SQL first must "wake up" ... – Gustav Sep 29 '21 at 17:34
  • I have used exactly the same like the link except last slide where connection failed. http://fmsinc.com/MicrosoftAccess/cloud/link-to-azure-sql-database.html Did many times.. but still no luck! I am sure there is something i have missed but not too knowledgeable on ODBC part. – KRMNDev Sep 29 '21 at 18:48

1 Answers1

1

You need to install ODBC driver 17 for SQL Server. You need to restart computer after installing the driver or the connection won't work. Create a Machine ODBC DSN using this driver.

enter image description here

Provide now the Azure SQL server name:

enter image description here

Use SQL authentication.

enter image description here

On the next screen specify the database name (catalog).

Make sure you set Encrypt=True

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30