Error code 0x2AF9 When trying to connect to docker created mssql server with ODBC drivers

Question

I am using Microsoft made images like mcr.microsoft.com/azure-sql-edge or mcr.microsoft.com/mssql/server:latest

within docker to create a test environment server. I have installed ODBC drivers from Microsoft as well (17 & 18) and am trying to connect my backend application to this server. I have no issues connecting to this server with Azure Data Studio but using connection string :

Driver={ODBC Driver 18 for SQL Server};Server=localhost;Database=tempdb;UID=sa;PWD=********;Connect Timeout=30;Encrypt=Yes;Trust Server Certificate=True;Authentication=SqlPassword;Command Timeout=30

results in the error code from the title. I have tried other common solutions like using 127.0.0.1 and such with little luck, any other solutions to this issue?

Answer 1

Hello

Thank you for posting in Microsoft Community forum.

Based on the description, I understand your question is related to the SQL Server.

Since there are no engineers dedicated to SQL Server in this forum. in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

Here is the link for Q&A forum.

Questions - Microsoft Q&A

Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag.

Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

Have a nice day.

Best Regards,

Molly

Answer 2

Did you find a solution to this?
I'm trying to do the same thing.. odd thing is, I can connect from DBeaver on my Macbook M1, but I can't connect from Excel on my Macbook M1 (although yesterday this was working, today it's not).
I can also connect from Excel on a Windows PC with no issues.