SQL Server服务无法启动 [英] SQL Server service failed to start

问题描述

安装sql server 2005时出现以下错误但已安装



SQL Server服务无法启动。有关详细信息，请参阅SQL Server联机丛书主题，如何：查看SQL Server 2005安装日志文件和手动启动SQL Server。



因此我尝试启动以下服务，但它没有开始，因为它显示如下错误

 msftesql $ SQLEXPRESS1234 
 MSSQL $ SQL2005 
 MSSQLServerADHelper 
 msftesql $ SMARTSQL2005 
 msftesql $ SQLEXPRESS 
 msftesql $ SQLEXPRESS123 
 msftesql $ SQLEXPRESS1234 
 MSSQL $ SQLEXPRESS1234 
 MSSQL $ SQLEXPRESS123 
 MSSQL $ SQLEXPRESS 
 SQLBrowser 

错误



Windows无法在本地计算机上启动sql server上述服务。



错误2：系统找不到指定的文件。



所以我试图登录但是它失败并显示消息如



错误：

与网络相关或特定于实例的错误或建立与SQL Server的连接时发生。服务器未找到或无法访问。 
 
验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供程序：SQL网络接口，错误：26  - 查找指定的服务器/实例时出错）（Microsoft SQL Server，错误：-1）

解决方案

< blockquote> SQLEXPRESS1234
MSSQL

SQL2005
MSSQLServerADHelper
msftesql

SMARTSQL2005
msftesql

while installing sql server 2005 following error came but installed

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.

so i tried to start these following services but it's not getting started because it shown bellow Error

msftesql$SQLEXPRESS1234
MSSQL$SQL2005
MSSQLServerADHelper
msftesql$SMARTSQL2005
msftesql$SQLEXPRESS
msftesql$SQLEXPRESS123
msftesql$SQLEXPRESS1234
MSSQL$SQLEXPRESS1234
MSSQL$SQLEXPRESS123
MSSQL$SQLEXPRESS
SQLBrowser

Error is

Windows could not start the sql server the above services on Local Computer.

Error2:The system cannot find the file specified.

so i am trying to login but it's got failure and showing message like

ERROR:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

解决方案

SQLEXPRESS1234 MSSQL

SQL2005 MSSQLServerADHelper msftesql

SMARTSQL2005 msftesql

这篇关于SQL Server服务无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！