Windows 无法在本地计算机上启动 SQL Server (SQLEXPRESS) 服务。错误1053
我运行的是 Windows 7 32 位,并且安装了 IIS、Visual Studio 2008、2010。我对 SQL Server 2008 中的这个错误感到困扰,它是:
Windows 无法在本地计算机上启动 SQL Server (SQLEXPRESS) 服务。错误1053:服务没有及时响应启动或控制请求
我已在 Google 上搜索并访问了许多其他站点。
我尝试过以下操作:
- 将帐户权限更改为本地系统帐户,但没有成功。
- 卸载并重新安装:没有运气。
- 检查客户端协议中的端口,将其设置为 1433。
- 将网络服务帐户添加到程序文件中的 Microsoft SQL Server 文件夹中。
我无法检查日志文件,因为它不存在于 MS SQL 文件夹的 LOG 文件夹中。 我已从有关此问题的修复文章中更改了注册表信息,但这些网站没有运气。
这真的很烦人,因为我之前安装了 SQL Server 2005 Express,但收到了相同的错误消息,因此我卸载了它并决定尝试一下 SQL Server 2008 Express,但我收到了相同的错误。
这确实减慢了我的速度,因为我已经在网站中开发了很多网页,现在我想向网站添加功能,并且我需要 SQL Server,这确实让我无法工作。
有人可以帮忙吗?我真的需要解决这个问题,我已经尝试了谷歌网站提供的所有内容。如果您需要更多信息,我们很乐意向您提供反馈,以便尽快解决此问题。
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 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
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.
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.
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.
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.
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
打开事件查看器并挖掘日志:
打开 Windows 资源管理器,然后转至
控制面板\所有控制面板项\管理工具
打开事件查看器
展开 Windows 日志
在应用程序、安全性和系统中查找错误。
Open the event viewer and dig through the logs:
Open Windows Explorer and go to
Control Panel\All Control Panel Items\Administrative Tools
Open Event Viewer
Expand Windows Logs
Look in Application, Security, and System for errors.
好消息。我终于成功安装了 SQL Server 2008 Express。我所做的是下载 Windows Install Cleanup。
但首先我从控制面板>程序>程序和功能中卸载了与 SQL Server 2008 相关的所有内容,包括 sql server vss writer、sql server browser。
然后我删除了regedit.exe中的文件夹,这些文件夹是HKEY_LOCAL_MACHINBE/software/microsoft/microsoft sql server中的sql server文件夹,基本上都是以microsoft sql server“xxxx”开头的文件夹。
我还从 Hkey_current_user/software/microsoft/microsoft sql server 中删除了 Microsoft sql server 目录。
然后我从系统上的程序文件中删除了 microsoft sql server 目录。一旦所有这些目录都从 regedit 和我的电脑中删除,
然后我成功安装了sql server 2008 Express。感谢所有花时间查看我的问题的人,也感谢那些给我反馈的人。
great news. i managed to install SQL Server 2008 Express at last. What i did was i downloaded Windows Install Cleanup.
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.
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".
I also deleted the Microsoft sql server directory from Hkey_current_user/software/microsoft/microsoft sql server.
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,
I then finally used Windows install cleanup and removed anything that related to microsoft sql server 2008 and thats it.
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.