SQL Server Management Studio 无法连接到 Sql Server
我已经使用 MS Web Platform Installer 2.0 安装了 Visual Web Developer 2010、SQL Server 2008 R2 和 SQL Management Studio 2008。但每当我想通过 Windows 身份验证 使用 Sql Management Studio 登录 SQL Server 时,它都会抛出一个错误:无法连接到(本地)
然后在下面,它说找不到服务器或无法访问它。
我以前用过Sql Management Studio 2005,可以轻松连接。但这个版本似乎存在一些问题。有人可以帮我吗?谢谢。
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)
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
如果您尝试访问,请在“SQL Server 配置管理器”中检查实例是否正确。
如果不是默认实例,则必须通过 << 访问计算机名称>\<实例名称> (例如:MyComputer\SQLEXPRESS)
如果仍然无法连接,请尝试替换 <计算机名称>通过“localhost”或“127.0.0.1”
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)
If still you do not connect, try the replace < computer_name > by "localhost" or "127.0.0.1"
您是否安装了多个版本的 SQL Server?
如果是这样,您将需要指定完整的实例名称。
Do you have multiple versions of SQL Server installed?
If so, you will need to specify the full instance name.