Visual Studio 2012和MS Sql Server 2012-与服务器资源管理器连接 [英] Visual Studio 2012 and MS Sql Server 2012 - connect with Server Explorer

问题描述

我在使用MS SQL Server 2012 Express在Visual Studio 2012 Ultimate中与Server Explorer建立连接时遇到问题.一切都在本地计算机上.

I have a problem establishing connection with Server Explorer in Visual Studio 2012 Ultimate with MS SQL server 2012 Express. Everything is on local machine.

您可以在此处看到屏幕截图- http://s16.postimage.org/4gvo7r5id/se_prob_ss1 .png

You can see screen shot here - http://s16.postimage.org/4gvo7r5id/se_prob_ss1.png

使用System.Data.SqlClient 和SqlConnection.Open()一切工作很好我能够连接和执行SQL脚本(带有和不带有Windows身份验证).

With System.Data.SqlClient and SqlConnection.Open() everything work fine I'm able to connect and execute SQL scripts (with and without Windows Authentication).

到目前为止我尝试过的事情:

What I tried so far:

• 我在Conncetions中在MS SQL Management Studio中签到"允许远程 连接到该服务器"(已选中)
• 在我的SQL Server的SQL Server配置管理器中，启用了TCP/IP协议
• 我尝试连接已关闭的防火墙和防病毒保护
• 我尝试使用新的登录名(使用System.Data.SqlClient.SqlConnection可以正常工作)

• I checked in MS SQL Management Studio in Conncetions "Allow remote connections to this server" (Checked)
• In SQL Server Configuration Manager on my SQL server TCP/IP protocol is enabled
• I tried to connect with turned off firewall and antivirus protection
• I tried with new Logins (with System.Data.SqlClient.SqlConnection it work)

推荐答案

在图中，您要连接的服务器名称显示错误.您表示已安装SQL Express；它具有默认实例名称SQLEXPRESS.因此，您要连接的服务器应该是:

In the picture, the server name you are connecting to appears wrong. You indicated you installed SQL Express; it has a default instance name of SQLEXPRESS. So the server you are connecting to should be:

MILLENIUM\SQLEXPRESS

不只是千年.

这篇关于Visual Studio 2012和MS Sql Server 2012-与服务器资源管理器连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！