Microsoft SQL Server 2005服务无法启动

I’ve been trying to install Ms SQL Server 2005 for over two weeks now, and I’ve finally gotten to the point where the prerequisites all seem to be in place. Unfortunately, every time I try to install SQL Server itself, I get the following message:

我一直在尝试安装Ms SQL Server 2005超过两周,而且我终于达到了先决条件似乎已经到位的程度。不幸的是,每次我尝试安装SQL Server本身时,都会收到以下消息:

“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."”

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

The installer then “rolls back” the install and I’m left with three uninstalled products in the Setup list: “SQL Server Database Services,” “Reporting Services,” and “Workstation Components, Books Online…”.

安装程序然后“回滚”安装,我在安装程序列表中留下了三个未安装的产品:“SQL Server数据库服务”,“Reporting Services”和“工作站组件,联机丛书...”。

Does anyone have any thoughts? I can’t check the SQL Server Books Online topics because they don’t install, either; and I can’t make sense of the log files without them.

有人有想法吗?我无法检查SQL Server联机丛书主题,因为它们也没有安装;如果没有它们,我无法理解日志文件。

Thanks!

9 个解决方案

#1

I had similar problem while installing SQL Server 2005 on Windows 7 Professional and got error SQL server failed to start. I logged in as a Administrator (my user id is administrator) in windows.

我在Windows 7 Professional上安装SQL Server 2005时遇到了类似的问题,并且SQL服务器无法启动时出错。我在Windows中以管理员身份登录(我的用户ID是管理员)。

SOLUTION

Go to services, from control panel -> Administrative Tools

从控制面板 - >管理工具转到服务
Click on properties of "SQL Server (MSSQLSERVER)"

单击“SQL Server(MSSQLSERVER)”的属性
Go to Log On Tab, Select "This Account"

转到登录选项卡,选择“此帐户”
Enter your windows login detail (administrator and password)

输入您的Windows登录详细信息(管理员和密码)
Start the service manually, it should work fine..

手动启动服务,它应该工作正常..

Hope this too helps..

希望这也有帮助..

#2

It looks like not all of your prerequisites are really working as they should be. Also, you'll want to make sure that you are installing from the console itself and not through any kind of remote session at all. (I know, this is a pain in the a@@, but sometimes it makes a difference.)

看起来并非所有先决条件都能按原样运行。此外,您需要确保从控制台本身进行安装,而不是通过任何类型的远程会话。 (我知道,这是一个@@的痛苦,但有时它会产生影响。)

You can acess the SQL Server 2005 Books Online on the Web at: http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx. This documentation should help you decipher the logs.

您可以在Web*问SQL Server 2005联机丛书:http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx。此文档应该可以帮助您解密日志。

Bonus tidbit: Once you get that far, if you plan on installing SP2 without getting an installation that fails and rolls back, another little pearl of wisdom is described here: http://blog.andreloker.de/post/2008/07/17/SQL-Server-hotfix-KB948109-fails-with-error-1920.aspx. (My issue was that the "SQL Server VSS Writer" (Service) was not even installed.) Good luck!

奖金花絮:一旦你走得那么远,如果你计划在没有安装失败并回滚的情况下安装SP2,那么这里将描述另一个小智慧:http://blog.andreloker.de/post/2008/07/ 17 / SQL-Server的修补程序-KB948109-失败与 - 错误1920.aspx。 (我的问题是甚至没有安装“SQL Server VSS Writer”(服务)。祝你好运!

#3

While that error message is on the screen (before the rollback begins) go to Control Panel -> Administrative Tools -> Services and see if the service is actually installed. Also check what account it is using to run as. If it's not using Local System, then double and triple check that the account it's using has rights to the program directory where MS SQL installed to.

当该错误消息出现在屏幕上时(在回滚开始之前),请转到“控制面板” - >“管理工具” - >“服务”,然后查看该服务是否已实际安装。还要检查它用于运行的帐户。如果它不使用本地系统,则双重和三重检查它使用的帐户是否具有安装MS SQL的程序目录的权限。

#4

We had a similar problem recently withour running SQL 2005 servers (more specifically: The reporting services). The windows services didn't start anymore with no real error message whatsoever.

我们最近在运行SQL 2005服务器时遇到了类似的问题(更具体地说:报告服务)。 Windows服务不再启动,没有任何真正的错误消息。

I found out that this problem was related to some KB hotfixes that have been deployed lately. For some reason those hotfixes resulted in the services taking longer than usually for starting up.

我发现这个问题与最近部署的一些KB修补程序有关。由于某些原因,这些修补程序导致服务的启动时间比通常更长。

Since by default, there is a timeout that kills the service after 30 seconds when it was not able to go beyond the start methods, this was the reason why it simply terminated.

因为默认情况下,超时会在30秒后杀死服务,因为它无法超越启动方法,这就是它终止的原因。

Maybe this is what you are experiencing.

也许这就是你所经历的。

Theres a work around described on Microsoft Connect (link). Although the hotfixes listed in this article didn't match the ones that have been deployed to our systems, the workaround worked for us.

这是在Microsoft Connect(链接)上描述的解决方法。虽然本文中列出的修补程序与已部署到我们系统的修补程序不匹配,但解决方法对我们有用。

#5

I'd try just installing the tools and database services to start with. leave analysis, Rs etc and see if you get further. I do remeber having issues with failed installs so be sure to go into add/remove programs and remove all the pieces that the uninstaller is leaving behind

我试着开始安装工具和数据库服务。离开分析,Rs等,看看你是否进一步。我确实记得安装失败的问题,所以一定要进入添加/删除程序并删除卸载程序留下的所有部分

#6

I have seen something similar before when the account the SQL Server is set to run under does not have the required permission.

在SQL Server设置为运行的帐户没有所需权限之前,我已经看到过类似的东西。

Tangentially, once it is installed, a common mistake is to change the login credentials from Windows Services, not from SQL Server Configuration Manager. Although they look the same, the SQL Server tool grants access to some registry keys that the Windows tool does not, which can cause a problem on service startup.

切换,一旦安装,常见的错误是从Windows服务而不是从SQL Server配置管理器更改登录凭据。虽然它们看起来相同,但SQL Server工具允许访问Windows工具不能访问的某些注册表项,这可能会导致服务启动时出现问题。

You can run Sysinternals RegMon/Sysinternals ProcessMon while the install is running, filtering by sqlsevr.exe and Failure messages to see if the account credentials are a problem.

您可以在安装运行时运行Sysinternals RegMon / Sysinternals ProcessMon,通过sqlsevr.exe和Failure消息进行筛选,以查看帐户凭据是否存在问题。

Hope this helps

希望这可以帮助

#7

I agree with Greg that the log is the best place to start. We've experienced something similar and the fix was to ensure that admins have full permissions to the registry location HKLM\System\CurrentControlSet\Control\WMI\Security prior to starting the installation. HTH.

我同意Greg的说法,日志是最好的起点。我们遇到过类似的问题,修复方法是确保管理员在开始安装之前对注册表位置HKLM \ System \ CurrentControlSet \ Control \ WMI \ Security具有完全权限。 HTH。

#8

To solve this problem, you may need to repair your SQL Server 2005

若要解决此问题,您可能需要修复SQL Server 2005

Simple steps can be

简单的步骤即可

Update/Install .Net 2.0 framework. Windows Installer 3.1 available online recommended

更新/安装.Net 2.0框架。建议在线安装Windows Installer 3.1

Download the setup files from Microsoft website : http://www.microsoft.com/en-in/download/details.aspx?id=184

从Microsoft网站下载安装文件:http://www.microsoft.com/en-in/download/details.aspx?id = 184

Follow the steps mentioned below from the Symantec website: http://www.symantec.com/connect/articles/install-and-configure-sql-server-2005-express

按照Symantec网站上提到的步骤操作:http://www.symantec.com/connect/articles/install-and-configure-sql-server-2005-express

Hope this helps!

希望这可以帮助!

#9

solution for the microsoft sql server 2005 failed to start

microsoft sql server 2005的解决方案无法启动

Read carefully all the tabs and icon name when you open it

打开时仔细阅读所有选项卡和图标名称

Don't be in a hurry be cool and do this procedure

不要急着冷静并做这个程序

Start your sql and proceed further when u get this error than start with this solution . do not quit the installation
start->control panel-->administrative tools-->services-->in services search for the sql server (sql express) -->click on logon (tab)--> check local system account & also check
service to interact with desktop -->click on recovery tab -->first failure choose restart the service ;second failure --> run the program --> apply ok

当你得到这个错误而不是从这个解决方案开始时,启动你的sql并继续前进。不要退出安装开始 - >控制面板 - >管理工具 - >服务 - >在服务中搜索sql server(sql express) - >点击登录(tab) - >查看本地系统帐号&还检查服务与桌面交互 - >点击恢复选项卡 - >首先失败选择重启服务;第二次失败 - >运行程序 - >应用ok

#1