提供命名管道提供程序错误40无法打开到SQL Server错误2的连接 [英] Provider named pipes provider error 40 could not open a connection to SQL Server error 2
问题描述
当我试图连接到我在SQL Server Management Studio数据库,我得到这个错误:
When I am trying to connect to my database in SQL Server Management Studio, I getting this error:
提供命名管道提供程序错误40无法打开到SQL Server错误连接
Provider named pipes provider error 40 could not open a connection to SQL Server error
在SO检查几个答案后,我打开SQL Server配置管理器
After checking several answers on SO, I opened the SQL Server Configuration Manager
我发现 SQLSERVER(SQLEX preSS)
和所有三个选项状态>> 结束
I found SQLSERVER (SQLEXPRESS)
and all three options state >> STOPPED
我试了一下通过右键单击开始,但我得到了以下错误:
I tried it starting by right clicking on it, but i got below error:
请求失败或服务及时没有回应
The request failed or the service did not respond in a timely fashion
我怎样才能连接到该实例???
How can I connect to the instance???
推荐答案
在控制面板中搜索服务
在那里你会找到和进入查看本地服务在管理工具栏目
Search for services in control panel, there you will find and entry View Local Services in Admin tool section
选择它,将在您的系统显示一个窗口,所有的服务,
找到你的服务的 SQLEX $ P $干燥综合征并点击开始即可。它应该启动服务器实例:)
select it that will show a window with all services in your system, find your service SQLEXPRESS and click on Start. It should start your server instance :)
这篇关于提供命名管道提供程序错误40无法打开到SQL Server错误2的连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!