CODEWITHSUNDEEP
sql-serverdockerwindows-subsystem-for-linux
Alen Smith
Alen Smith

Reputation: 1512

Can't Connect "SSMS on Windows" With "SQLServer on Linux" Container On Docker

I've pulled latest SQL Server docker image

docker pull mcr.microsoft.com/mssql/server

Then started with port 1400. (I'm not using default port 1434 because I've a local instance of SQLServer running outside of docker which my SSMS can quickly connect)

docker run  -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=pa$$word@123" -e "MSSQL_PID=Express" --name "SQLServer" -p 1400:1400 -d mcr.microsoft.com/mssql/server

This is my container info enter image description here

When I check the logs everything looks normal. But when I try to connect from SSMS, I'm getting the following error. enter image description here

What could be the reason? I'm also planning to build a .NET Core application to connect to this docker image but now I've concerns regarding if it's some TLS version mismatch.

Upvotes: 1

Views: 232

Answers (1)

Alen Smith
Alen Smith

Reputation: 1512

I found the solution. I need to specify the instance name in SSMS in order to connect to it enter image description here

Upvotes: 2

Related Questions