sql网络接口错误26-错误指定服务器/实例的位置 [英] sql network interfaces error 26 - error locating server/instance specified

问题描述

好吧，很多人都提出了类似的问题，但是我似乎无法在任何一个人中找到解决我问题的方法.这就是我的情况.

Okay so a lot of people have posted a similar question, however I don't seem to be able to find a solution to my problem in any of them. So this is my situation.

昨天，我通过SQL Server Management Studio使用SQL Server Express.我之前已经做过多次，所以关闭了我的项目.今天早晨，当我尝试再次使用该工具进行连接时，出现此错误:

Yesterday I was working with my SQL Server Express through SQL Server Management Studio. I close my projects as I've done multiple times before and then this morning when I tried to connect again with the tool is gives me this error:

标题:连接到服务器

TITLE: Connect to Server

无法连接到.\ SQLExpress.

Cannot connect to .\SQLExpress.

其他信息:

建立与SQL Server的连接时发生与网络相关或特定于实例的错误.
服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:SQL网络接口，错误:26-错误指定服务器/实例的位置)(Microsoft SQL Server，错误:-1)

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)

我认为我的主要问题是是否可以解决此问题，或者是否必须重新安装SQL Server Express?

I think my main question here is if there is a solution to this problem, or if I have to install SQL Server Express all over again?

PS:以下是一些系统统计信息.我正在使用Windows 10计算机，SQL Server Management Studio版本是2014.

PS: Here are some system stats. I'm working on a Windows 10 machine, and the SQL Server Management Studio version is 2014.

推荐答案

1. 打开SQL Server配置管理器

1. Open SQL Server Configuration Manager

单击SQL Server Network Configuration并单击Protocols for Name

右键单击TCP/IP(确保已启用)，然后单击Properties

Right click on TCP/IP (make sure it is Enabled), click on Properties

选择IP Addresses选项卡并转到最后一个条目:IP All

Select IP Addresses Tab and go to the last entry: IP All

输入TCP Port 1433.

现在重新启动"SQL Server .Name".使用services.msc(winKey + r)

Now restart "SQL Server .Name." using services.msc (winKey + r)

这篇关于sql网络接口错误26-错误指定服务器/实例的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！