SQL Server Management Studio 无法连接到 Sql Server
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4214625/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server Management Studio won't connect to Sql Server
提问by Shaoz
I've installed Visual Web Developer 2010, SQL Server 2008 R2 and SQL Management Studio 2008, using the MS Web Platform Installer 2.0. But whenever I wanna login, with Windows Authentication, to SQL Server with the Sql Management Studio it throws me an error: Cannot connect to (local)
我已经使用 MS Web Platform Installer 2.0 安装了 Visual Web Developer 2010、SQL Server 2008 R2 和 SQL Management Studio 2008。但是每当我想使用Windows 身份验证登录到带有 Sql Management Studio 的 SQL Server 时，它都会抛出一个错误：无法连接到（本地）
And then under that, it says that it can't find the server or it can't access it.
然后在此之下，它说它找不到服务器或无法访问它。
I used to use the Sql Management Studio 2005 before and I could connect easily. But with this version it seems there are some issues. Can someone help me, please? Thank you.
之前用过Sql Management Studio 2005，连接很方便。但是这个版本似乎存在一些问题。有人能帮助我吗？谢谢你。
回答by bodee
Check in the "SQL Server Configuration Manager" the instance is correct if you are trying to access. If it is not the default instance, you must access by < computer_name >\< instance_name > (eg: MyComputer\SQLEXPRESS)
如果您尝试访问，请检查“SQL Server 配置管理器”实例是否正确。如果不是默认实例，则必须通过<计算机名称>\<实例名称>访问（例如：MyComputer\SQLEXPRESS）
If still you do not connect, try the replace < computer_name > by "localhost" or "127.0.0.1"
如果仍然无法连接，请尝试将 <computer_name> 替换为“localhost”或“127.0.0.1”
回答by Mitch Wheat
Do you have multiple versions of SQL Server installed?
您是否安装了多个版本的 SQL Server？
If so, you will need to specify the full instance name.
如果是这样，您将需要指定完整的实例名称。
