Vb.net (Visual Basic) Connectivity from Parallels Windows 10 VM to Docker Azure SQL Edge on MAC Big Sur

I have Docker Azure SQL Edge running on MAC. I have a Parallels Win 10 running on my MAC Inside my Parallels Win 10, I have SSMS running and I can connect to the docker SQL using IPADDRESS(ofMac)\SQLEXPRESS,1433 and SA account.

I can connect to the Docker SQL Server on the MAC from my vb.net app in the Parallels Windows 10 VM. It connects and opens to the form where I select the database I want to open. It is here where I am getting an error. It says "CONTAINERID"\Guest login not found. I tried the connection string to use SA and I get same error. I tried connection string to use Integrated Security = SSPI and same error. The vb.net desktop app is trying to use windows authentication to connect and open the DB. And it is failing.

So I can connect to the SQL Docker image on my MAC from my VB.net desktop App running inside my Parallels Windows 10 Home Image. I just can't open a DB due to windows authentication failing.

Here are some details:

docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=1234Abcd" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge

I get this error: login failed for edcdded46cc9\Guest when I try to open a DB. I can connect to the docker SQL Server using SA no problem. When I try to connect and open a DB on the server, I get the error.

This line in my VB code is throwing the error:

mycomstr = Provider=sqloledb;Data Source=\SQLEXPRESS,1433;Initial Catalog=CHOICEWORX-A;Integrated Security=SSPI;

I also tried the above string with SA account. I get same error.

SQL Docker Logs:

2021-10-23 23:09:53.59 Logon Login failed for user 'edcdded46cc9\Guest'. Reason: Could not find a login matching the name provided. [CLIENT:] 2021-10-23 23:12:54.15 spid61 [10]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. 2021-10-23 23:12:54.15 spid61 Starting up database 'CHOICEWORX-A'. 2021-10-23 23:12:54.24 spid61 Parallel redo is started for database 'CHOICEWORX-A' with worker pool size [2]. 2021-10-23 23:12:54.28 spid61 Parallel redo is shutdown for database 'CHOICEWORX-A' with worker pool size [2]. 2021-10-24 01:11:27.22 Logon Error: 18456, Severity: 14, State: 5. 2021-10-24 01:11:27.22 Logon Login failed for user 'edcdded46cc9\Guest'. Reason: Could not find a login matching the name provided. [CLIENT:] imadlodhi@Imads-MacBook-Air ~ %

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum