Can't connect to SQL Server - service missing

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)

And the SQL Server service (MSSQLServer) is missing!

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

I try to run reinstall.exe to fix SQL Server 2008, but it shows database engine failure!

Answer 1

you can review the event viewer of windows to see the problem. You can also check the firewall is not blocking port sql server.

More details in this links

• Enable service sql server 2008 http://technet.microsoft.com/en-us/library/ms191454(v=sql.105).aspx
• Enable connection remote sql server 2008 http://technet.microsoft.com/en-us/library/ms191464.aspx