本文介绍了SQL Server 2008 R2 无法连接到 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)\SQLEXPRESSyourMachineName\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 中的本地数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-21 08:34