无法将SSMS连接到sql server express的容器实例 [英] Can't connect SSMS to container instance of sql server express

问题描述

正如标题所述，我无法将SSMS连接到我的本地microsoft / mssql-server-2016-express-windows容器。使用docker版本1.12.3-beta30.1（8711）并切换到windows容器，我运行以下docker命令。

As the title states, I am having trouble connecting SSMS to my local microsoft/mssql-server-2016-express-windows container. Using docker version 1.12.3-beta30.1 (8711) and switching to windows containers I run the following docker command.

docker run -d -p 1433：1433 - env sa_password = 34B1dKdXzoUB -it microsoft / mssql-server-2016-express-windows

（密码是由工具随机生成的）

(password was randomly generated by a tool)

如果我查看kitematic中的日志输出，我看到容器已正确启动：

If I look at the log output in kitematic i see that the container was started properly:

但当我尝试使用SSMS登录服务器时，服务器为localhost \sqlexpress，我相信它是基于的默认实例github docs 

But when i attempt to log on to the server using SSMS  with the server as localhost\sqlexpress which i believe to be the default instance based on the github docs 

运行docker run命令或尝试连接SSMS时是否缺少某些内容？

Is there something I am missing when running the docker run command or when trying to connect with SSMS?

任何帮助你可以提供赞赏。

Any help you can provide is appreciated.

谢谢。

推荐答案

尝试在主机名后面添加端口，如下所示：

Try adding the port right after the hostname, like so:

localhost,1433\sqlexpress

问候，

Dimitar

Regards,
Dimitar

这篇关于无法将SSMS连接到sql server express的容器实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！