Let us take a closer look at how to access docker from SSMS. At Bobcares with the support of our Docker hosting support services we can detailed overview of the entire process.

How to access Docker from SSMS?

The default SQL client port 1433 is used by SSMS. The SQL Server images from Microsoft and this book already have everything set up, so we don’t need to expose any more ports or start any new services with the SSM. With the SA credentials we use to operate the container, we can login using SQL Server authentication.

Using the SA credentials and publishing port 1433 to the host, this program launches a SQL Server 2019 Express Edition container:

docker container run -d -p 1433:1433 ` -e sa_password=DockerOnW!nd0ws ` --name sql ` dockeronwindows/ch03-sql-server:2e

There are three ways to connect to the SQL Server within the container as a result of this publishing the usual SQL Server port 1433:

Using SSMS to remote access the docker container

• Use the public IP address, followed by a comma separator, followed by the port to connect using SSMS (xxx.xx.xx.xxx,port). To make this work, we also need the SA credentials.
• Server Name input changes to Server IP, Port#.
• Use localhost IP to connect to the Docker container on the local PC using SSMS. In such scenario, entering the Server Name will result in 127.0.0.1,port#.

With the support of the SSMS, we can instantly connect to the SQL Server instantly from SSMS. Try the command line given below to set this option up easily.

docker run --name mssqltrek-con1 -d -p 1433:1433 -e sa_password=My$eCurePwd123# -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer.

After doing this, we can use the following to get the right IP to finalise the access docker from ssms:

docker inspect -f "{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}" mssqltrek-con1


[Need assistance with similar queries? We are here to help]

Conclusion

To conclude we have learned how to access docker from SSMS with our Docker hosting support services. We went through how to connect remotely to the Docker container using SQL Server Management Studio.