SQL Server Management Studio中无法连接 [英] SQL Server Management Studio can not connect

问题描述

我已经安装了SQL Server Management Studio中2014年连接到服务器窗口中，选中我的服务器类型为数据库引擎，服务器名称为（本地），但是当我尝试连接，正误差shown-

标题：连接到服务器

无法连接到..

附加信息：

一个网络相关的或建立到SQL Server的连接发生特定实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server配置为允许远程连接。 （provider：命名管道提供程序，error：40 - 无法打开到SQL Server的连接）（微软SQL Server，错误：2）

请帮忙怎么办...

解决方案

一个与网络相关的或特定于实例而与SQL Server建立连接时出现错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server配置为允许远程连接。 （provider：命名管道提供程序，error：40 - 无法打开到SQL Server的连接）（微软SQL Server，错误：2）

< 。p>这是连接到与Management Studio中的SQL Server时，它产生一个常见的​​错误

这包括像不同类型的错误情况（服务 - 不适用），（服务不运行），（网络图书馆 - 未启用），（火墙阻挡）等。

请排查系统的方式。

1. 点击开始按钮，然后键入 SERVICES.MSC




2. 检查SQL Server服务是否已安装并运行正常。

请。检查是否启动或没有服务

如果是：

• 下一步方案是网络库调。

如果没有

• 从软件包安装SQL Server引擎和启动服务。

I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server name as "(local)" but when I try to connect, n error is shown-

TITLE: Connect to Server

Cannot connect to ..

ADDITIONAL INFORMATION:

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)

Please help what to do...

解决方案

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)

This is a common error which arises when connecting to SQL Server with Management Studio.

This includes different type of error scenarios like (Service--Not Available),(Service-Not Running),(Network Library- Not Enabled),(Fire Wall-Blocking) Etc.

Please troubleshoot in systematic manner.

1. Click On start button and type Services.MSC

2. Check whether the SQL Server service has been installed and is running fine.

Please check the service whether started or not.

If Yes:

• Next Scenario is Network Libraries Tune.

If No

• Install the SQL Server Engine from the software package and start the service.

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