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!

Improve this question
3
  • Can you post connection setup from both ODBC Admin and SSMS (without authentication info of course) Commented Sep 29, 2021 at 16:34
  • Try once more. Sometimes Azure SQL first must "wake up" ... Commented Sep 29, 2021 at 17:34
  • I have used exactly the same like the link except last slide where connection failed. fmsinc.com/MicrosoftAccess/cloud/… Did many times.. but still no luck! I am sure there is something i have missed but not too knowledgeable on ODBC part. Commented Sep 29, 2021 at 18:48

1 Answer 1

Reset to default
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

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

I did exactly the same way you showed. Still its not working..
@KRMNDev Please put "Encrypt=True"
Are you using exactly the same login in SSMS? Have you whitelisted your IP address in Azure?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.