sql server上的网络相关错误26，无法连接到服务器 [英] network related error 26 on sql server and cannot connect to server

问题描述

我无法连接我的服务器从早上开始。如下所示。我用Google搜索但我无法解决这个问题

------------ ------------------



无法连接到PC\SQLEXPRESS。



------------------------------

附加信息：
 
发生与网络相关的或特定于实例的错误 建立连接到 SQL Server。服务器未找到或 不无障碍。验证实例名称 正确和 SQL Server 是配置 允许远程连接。 （提供程序：SQL网络接口，错误： 26   - 查找指定的服务器/实例时出错）（Microsoft SQL Server，错误：-1）

< br $>


------------------------------





我试过这个，

 SQL配置经理 - > 
 Sql服务器服务
  - > Sql Server已停止

i我试图重启Sql server服务，抛出异常

解决方案

您需要为SQL Express启用网络，因为它是默认的：如何：在SQL Server配置管理器（SQL Server Express）中启用网络访问 [ ^ ]

检查：SQL网络接口，错误：26 - 错误找到指定的服务器/实例 [ ^ ]

I couldn't Connect my Server From the morning .it Says like below .I googled it but i couldn't Solve that issue
------------------------------

Cannot connect to PC\SQLEXPRESS.

------------------------------

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

------------------------------


I have Tried this,

SQL Configuration Manager ->
Sql Sever Services
-> Sql Server is Stopped

i am trying To Restart the Sql server services , its throw Exception

解决方案

You need to enable networking for SQL Express since it is off be default : How to: Enable Network Access in SQL Server Configuration Manager (SQL Server Express)[^]

Check this: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified[^]

这篇关于sql server上的网络相关错误26，无法连接到服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！