Windows 无法在本地计算机上启动 SQL Server (SQLEXPRESS) 服务。错误 1053

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4467053/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 08:36:18  来源:igfitidea点击:

Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053

sqlsql-serverdatabasesql-server-expresssql-server-2008-r2

提问by redoc01

I am running Windows 7 32 bit and I have IIS, Visual Studio 2008, 2010 installed. I am haunted by this error in SQL Server 2008 which is:

我正在运行 Windows 7 32 位,并且安装了 IIS、Visual Studio 2008、2010。我被 SQL Server 2008 中的这个错误困扰,它是:

Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053: The service did not respond to the start or control request in a timely fashion

Windows 无法在本地计算机上启动 SQL Server (SQLEXPRESS) 服务。错误 1053:服务没有及时响应启动或控制请求

I have Googled and visited many other sites.

我用谷歌搜索并访问了许多其他网站。

I have tried following:

我试过以下:

  • changed Account permission to Local System Account and no luck.
  • uninstalled and re-installed: no luck.
  • checked the port in Client Protocols and it is set 1433.
  • added Network Service account to the Microsoft SQL Server folder in program files.
  • 将帐户权限更改为本地系统帐户,但没有运气。
  • 卸载并重新安装:没有运气。
  • 检查客户端协议中的端口,它设置为 1433。
  • 在程序文件中的 Microsoft SQL Server 文件夹中添加了网络服务帐户。

I cant check the log file because it doesn't exist in the LOG folder of MS SQL folder. I have changed registry information from fix articles about this issue but no luck from those sites.

我无法检查日志文件,因为它不存在于 MS SQL 文件夹的 LOG 文件夹中。我已经更改了有关此问题的修复文章中的注册表信息,但这些站点没有运气。

It is really annoying because i installed SQL Server 2005 Express earlier and I got the same error message so that's why I uninstalled this and decided to give SQL Server 2008 Express a go and I receive the same error.

这真的很烦人,因为我之前安装了 SQL Server 2005 Express 并且收到了相同的错误消息,所以这就是我卸载它并决定试用 SQL Server 2008 Express 的原因,但我收到了同样的错误。

This is really slowing me down because I have developed a lot of the web pages in my website and now I want to add functionality to the site and I need SQL Server and this has really stopped me from working.

这真的让我慢了下来,因为我在我的网站上开发了很多网页,现在我想为网站添加功能,我需要 SQL Server,这真的让我无法工作。

Can someone help please? I really need to get this fixed i have tried everything that the sites provide in Google. If you require more information ill be glad to give you the feedback to get this solved as soon as possible.

有人可以帮忙吗?我真的需要解决这个问题,我已经尝试了网站在 Google 中提供的所有内容。如果您需要更多信息,我们很乐意为您提供反馈以尽快解决此问题。

回答by brian

Open the event viewer and dig through the logs: Open Windows Explorer and go to

打开事件查看器并查看日志:打开 Windows 资源管理器并转到

Control Panel\All Control Panel Items\Administrative Tools

控制面板\所有控制面板项目\管理工具

Open Event Viewer

打开事件查看器

Expand Windows Logs

展开 Windows 日志

Look in Application, Security, and System for errors.

在应用程序、安全性和系统中查找错误。

回答by redoc01

great news. i managed to install SQL Server 2008 Express at last. What i did was i downloaded Windows Install Cleanup.

好消息。我终于成功安装了 SQL Server 2008 Express。我所做的是下载了 Windows Install Cleanup。

  1. But first i uninstalled everything that relates to SQL Server 2008 from controlpanel>programs>programs and features including the sql server vss writer, sql server browser.

  2. Then i deleted the folders from regedit.exe and these folders were the sql server folders in HKEY_LOCAL_MACHINBE/software/microsoft/microsoft sql server,basically all the folders that start with microsoft sql server "xxxx".

  3. I also deleted the Microsoft sql server directory from Hkey_current_user/software/microsoft/microsoft sql server.

  4. Then i deleted the microsoft sql server directory from my program files on the system. once all these directories were removed from regedit and my pc,

  5. I then finally used Windows install cleanup and removed anything that related to microsoft sql server 2008 and thats it.

  6. I then installed sql server 2008 Express sucessfully. thanks for all the people who took the time to view my issue and thanks for those who gave me the feedback.

  1. 但首先我从控制面板>程序>程序和功能中卸载了与 SQL Server 2008 相关的所有内容,包括 sql server vss writer、sql server 浏览器。

  2. 然后我从 regedit.exe 中删除了文件夹,这些文件夹是 HKEY_LOCAL_MACHINBE/software/microsoft/microsoft sql server 中的 sql server 文件夹,基本上所有以 microsoft sql server "xxxx" 开头的文件夹。

  3. 我还从 Hkey_current_user/software/microsoft/microsoft sql server 中删除了 Microsoft sql server 目录。

  4. 然后我从系统上的程序文件中删除了 microsoft sql server 目录。一旦所有这些目录从 regedit 和我的电脑中删除,

  5. 然后我最终使用了 Windows 安装清理并删除了与 microsoft sql server 2008 相关的任何内容,仅此而已。

  6. 然后我成功安装了sql server 2008 Express。感谢所有花时间查看我的问题的人,感谢那些给我反馈的人。