当我尝试连接SQL Server时,我得到以下错误:
在建立与SQL Server的连接时,发生了与网络相关或特定于实例的错误。未找到服务器或无法访问服务器。验证实例名称是否正确,SQL Server是否配置为允许远程连接。(提供商:Named Pipes提供商,错误:40 -无法打开到SQL Server的连接)
当我试图在Visual Studio 2010中将数据库配置为gridview时抛出此错误。我不知道如何调试这个错误。
如何调试此错误?除了错误消息中提到的步骤之外,我还应该采取哪些步骤来确定这里到底发生了什么?
I had the same issue after upgrading my Windows to Windows Pro 10 21H2. I have two SQL instances - 2014 and 2019 and I was not able to connect only to 2019 one.
I restarted the computer, restarted all SQL related services. Two of the services were showing errors (SQL Server and SQL Server agent) and I was not able to start them.
I could not also start these two services from C:\Windows\SysWOW64\SQLServerManager15.msc
In the logs (C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER01\MSSQL\Log) I saw these lines:
Initializing the FallBack certificate failed with error code: 15, state: 29, error number: 0.
Error: 17190, Severity: 16, State: 1.
Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
Error: 17826, Severity: 18, State: 3.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
Error: 17120, Severity: 16, State: 1.
SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
原来在升级后,服务的“Log On”属性(服务属性上的第二个选项卡)被设置为NT AUTHORITY\NETWORK SERVICES。当我将其更改为“本地系统帐户”时,我能够启动服务并连接到MS SQL 2019实例。
这个msdn论坛的帖子帮助我找到了这个。
这个解决方案解决了SQL服务器背后的网络错误和服务问题
我在这里回答了一个类似的问题,您需要统计其他开放运行类型->服务。msc -在服务->排序停止你会看到一堆停止的SQL服务右键单击并启动
开始-有4个问题可能会导致常见的LocalDb SqlExpress Sql Server连接错误Sql网络接口,错误:50 -本地数据库运行时错误发生,在开始之前,您需要将v11或v12重命名为(LocalDb)\mssqllocaldb
Troubleshooting Steps
您没有正在运行的服务,执行命令net start MSSQLSERVER或net start MSSQL$ instancename
这里没有防火墙端口
配置
你的安装有问题/损坏(下面的步骤可以帮助你一个干净的开始)
您没有将V11或12重命名为mssqllocaldb/SqlServer
我发现最简单的是做下面的事情——我附上了图片和步骤以寻求帮助。
Resolution Steps:
首先验证您已经安装了哪个实例,您可以通过检查注册表并运行cmd来完成此操作
i .执行命令> Sqllocaldb.exe
cmd> Sqllocaldb.exe s "那个versionyouwantfromlistbefore "
如果此步骤失败,可以使用选项d删除cmd> Sqllocaldb.exe d "someDb"
cmd> Sqllocaldb.exe c "createSomeNewDbIfyouWantDb"
cmd> Sqllocaldb.exe start "createSomeNewDbIfyouWantDb"
重新启动MSSql服务器或简单地重新启动您的机器!
按住/按打开CMD,窗口+ R,输入“services.msc”
现在寻找sql server服务,打开查找带有实例名的sql server
然后重新启动此服务并重试