问题描述
我使用的是 SQL Server 2008 R2 Express.
I am using SQL Server 2008 R2 Express.
我首先安装了 SQL Server 2008 R2 Express Management Studio，然后安装了 SQL Server 2008 R2 Express.我有实例 SQLEXPRESS 正在运行，它被设置为自动.
I first installed SQL Server 2008 R2 Express Management Studio and then I installed SQL Server 2008 R2 Express. I have the instance SQLEXPRESS running and it is set to automatic.
我正在尝试使用 Windows 身份验证在本地连接到它 - 服务器名称设置为本地，用户名变灰并设置为我的个人资料用户名.
I am trying to connect to it locally using Windows authentication - server name is set to local and the username is grayed out and set to my profile username.
当我尝试连接时出现以下错误:
When I try to connect I get the following error:
我是否安装了错误的 SQL Server Management Studio?
Have I installed the wrong SQL Server Management Studio?
推荐答案
如果你的实例叫做SQLEXPRESS，那么你需要使用.\SQLEXPRESS或(local)\SQLEXPRESS 或 yourMachineName\SQLEXPRESS 作为您的服务器名称 - 如果您有一个 命名实例，则需要在您的服务器名称.
If your instance is called SQLEXPRESS, then you need to use .\SQLEXPRESS or (local)\SQLEXPRESS or yourMachineName\SQLEXPRESS as your server name - if you have a named instance, you need to specify that name of the instance in your server name.
这篇关于SQL Server 2008 R2 无法连接到 Management Studio 中的本地数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！