从 Virtual PC 连接到 SQL Server
我的桌面上安装了 VS 2008 和 SQL Server 2005 Developer 版本。 我有一个在 Virtual PC 中运行的 XP 实例，并且想要连接到开发实例。 我以域用户身份登录 XP 的桌面和虚拟实例。 当我尝试连接时，收到一条消息“服务器不存在或访问被拒绝”。 我需要做什么才能连接。 我正在使用可信连接，并且用户 ID 对数据库具有权限。
保罗
I have VS 2008 and SQL Server 2005 Developer edition installed on my desktop. I have a instance of XP running in Virtual PC and want to connect to the dev instance. I am logged on as a domain user on both the desktop and the Virtual instance of XP. When I try to connect I get a message saying "Server does not exist or access denied". What do I need to do to connect. I am using trusted connection and the userid has privileges on the DB.
Paul
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
确保 VPC 未使用 NAT 进行网络连接。
另请检查您的配置以确保允许远程连接。 远程连接默认关闭。
Make sure that the VPC is not using NAT for its network connection.
Also check your configuration to be sure remote connections are allowed. Remote connection is turned off by default.
您是否尝试过从虚拟实例 ping 您的桌面？ 我遇到了同样的问题，并发现防火墙阻止了两台机器之间的任何类型的通信。
Have you tried pinging your desktop from the virtual instance? I had the same problem and figured out that the firewall was preventing any kind of communication between both machines.
我发现您必须进入 SQL Server Surface Area Configuration 工具并将“远程连接”设置为“本地和远程连接”。 显然默认设置是“仅限本地连接”。
I found out that you have to go into the SQL Server Surface Area Configuration tool and set "Remote Connections" to "Local and remote connections". Apparently the default is "Local connections only".
我遇到了同样的事情，有点 - MS Server 2003 和 SQLServer 2008 Ent 在 VMWare 上运行，并在尝试从主机（在 Vista x64 上）连接时收到“服务器不存在或访问被拒绝”。
那么，您认为通过 SQL Server 外围区域配置工具更改为“本地和远程连接”可以解决问题吗？
I encountered the same thing, sort of - MS Server 2003 and SQLServer 2008 Ent running on VMWare, and get the "Server does not exist or access denied" when trying to connect from host machine (on Vista x64).
SO, do you reckon changing to "Local and remote connections" via the SQL Server Surface Area Configuration tool will do the trick?
对于我来说，尽管也为远程连接配置了 SQL 服务器，但我无法从 Win XP VM 访问 SQL 服务器。
所以当我从主机禁用 Windows 防火墙时，它工作得很好！
For me despite configuring the SQL server for Remote Connections also, I could not access the sql server from Win XP VM.
So when I disabled the windows firewall from host machine, it worked fine!!