无法连接到本地 SQL Server Express 2008 R2 [英] Cannot connect to local SQL Server Express 2008 R2

问题描述

我刚刚安装了 SQL Server Express 2008 R2，但在使用 SQL Server Management Studio(本地)连接到它时遇到问题.

I just installed SQL Server Express 2008 R2 and I have a problem connecting to it using the SQL Server Management Studio (locally).

所有SQL Server服务都启动了(SQL Server(SQLEXPRESS)，SQL Server浏览器，还有DTC服务)

All SQL Server services are started (SQL Server (SQLEXPRESS), SQL Server browser, also the DTC service)

当我尝试连接时，我收到以下消息:

When I try to connect I get the following message:

标题:连接到服务器

无法连接到(本地).

附加信息:

与网络相关或特定于实例的建立时发生错误连接到 SQL Server.服务器未找到或无法访问.验证实例名称是否为正确，并且 SQL Server 是配置为允许远程连接.(提供者:命名管道提供程序，错误:40 - 无法打开到 SQL Server 的连接)(MicrosoftSQL Server，错误:2)

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

推荐答案

您是否连接到本地 express 实例?试试这个作为你的服务器:.\SQLEXPRESS

Are you connecting to the local express instance? Try this as your server: .\SQLEXPRESS

这篇关于无法连接到本地 SQL Server Express 2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！