sql-server - 虚拟机之间无法连接sql server
问题描述
我有两个虚拟机(1-2)。它们都具有相同的操作系统版本(Windows Server 2012 R2)和 SQL Enterprise 版本。但是,我可以从 server1 连接到 server2。但无法连接到服务器 1。我添加了异常端口 1433(SQL Server 默认为防火墙)。如何解决这个问题呢?我也可以从本地计算机连接到 server2。
解决方案
My guess would be that 'allow remote access' hasn't been enabled. Its switched off in the installation by default for security reasons. So unless it has been turned on...
If that doesn't help, check Microsoft's guide to troubleshooting database connections which has some good guidance.
推荐阅读
- docker - Docker 更改现有镜像
- python - boto3中如何设置SQS消息类?
- javascript - When function triggers, inside for loop number return default value again
- html - iframe 与 src 中的 scriplet jsp
- python - rename the files with same names in different folders
- java - 快速查找大量阶乘的方法
- sql - 对 6 GB 表的昂贵查询
- batch-file - 将本地端口添加到现有 Windows 防火墙规则
- java - Monitoring number of consumer for the Kafka topic
- javascript - Create a Seekbar like vimeo video player (HTML5)