启动SQL Server时出现连接错误[重复]

时间:2021-11-29 17:04:23

This question already has an answer here:

这个问题在这里已有答案:

I have installed SQL Server 2014, and I did not specify any password and username, preferred Windows authentication. At the very first time the server connection was successful. But later on this error keeps showing up and the connection fails :

我已经安装了SQL Server 2014,并且我没有指定任何密码和用户名,首选Windows身份验证。在第一次服务器连接成功。但后来这个错误不断出现,连接失败:

Server error connection
Cannot connect to DESKTOP-4JBE86H

服务器错误连接无法连接到DESKTOP-4JBE86H

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.( and some additional explanation)
The system cannot find the file specified.

建立与SQL Server的连接时发生与网络相关或特定于实例的错误。找不到服务器或无法访问服务器。(以及一些其他说明)系统找不到指定的文件。

2 个解决方案

#1


0  

Probably your SQL services are not working the easiest way to start them is to open cmd with admin rights and type

可能你的SQL服务不起作用最简单的启动方式是打开具有管理员权限和类型的cmd

net start mssqlserver

And you are good to go

你很高兴

#2


0  

See if the service is standing, and also verify that port 1433 is enabled for network access on the firewall

查看服务是否正常,并验证端口1433是否已在防火墙上启用网络访问

#1


0  

Probably your SQL services are not working the easiest way to start them is to open cmd with admin rights and type

可能你的SQL服务不起作用最简单的启动方式是打开具有管理员权限和类型的cmd

net start mssqlserver

And you are good to go

你很高兴

#2


0  

See if the service is standing, and also verify that port 1433 is enabled for network access on the firewall

查看服务是否正常,并验证端口1433是否已在防火墙上启用网络访问