SQL Server 2008 R2 无法连接到 Management Studio 中的本地数据库 [英] SQL Server 2008 R2 can't connect to local database in Management Studio

问题描述

我使用的是 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 中的本地数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！