sql - 无法连接到 SQL Server - 缺少服务

Question

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

并且缺少 SQL Server 服务 (MSSQLServer)!

Name    State   Start Mode  Log On As   Process ID  Service Type

SQL Server Integration Services 10.0    Running Manual  NT AUTHORITY\NETWORKSERVICE 7020    SSIS Server

SQL Server Analysis Services (MSSQLSERVER)  Running Manual  NT AUTHORITY\LOCALSERVICE   7580    Analysis Server

SQL Server Reporting Services (MSSQLSERVER) Running Manual  NT AUTHORITY\LOCALSERVICE   6240    ReportServer

SQL Server Browser  Running Manual  NT AUTHORITY\LOCALSERVICE   9556    SQL Browser

我尝试运行 reinstall.exe 来修复 SQL Server 2008，但它显示数据库引擎故障!

Answer 1

您可以查看Windows 的事件查看器 来查看问题。您还可以检查防火墙是否阻止了 sql server 端口。

此链接中的更多详细信息

• 启用服务 sql server 2008 http://technet.microsoft.com/en-us/library/ms191454(v=sql.105).aspx
• 启用连接远程 sql server 2008 http://technet.microsoft.com/en-us/library/ms191464.aspx