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=192.168.0.153\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: 172.17.0.1] 2021-10-23 23:12:54.15 spid61 . 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 . 2021-10-23 23:12:54.28 spid61 Parallel redo is shutdown for database 'CHOICEWORX-A' with worker pool size . 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: 172.17.0.1] imadlodhi@Imads-MacBook-Air ~ %