SQL Server(SQLEXPRESS) 服务 [英] SQL Server(SQLEXPRESS) Service

问题描述

我正在尝试从 Sql Server 配置管理器启动 SQL Server(SQLEXPRESS) 服务.我收到以下错误:

I am trying to start SQL Server(SQLEXPRESS) service from Sql Server Configuration Manager. I got following error:

请求失败或服务没有及时响应.有关详细信息，请查阅事件日志或其他应用程序错误日志.

The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details.

我检查了错误日志.这是错误:

I checked out error logs. Here is the error:

initerrlog:无法打开错误日志文件C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG".操作系统错误 = 3

initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'. Operating system error = 3

我怎样才能做到这一点?

How can I achieve this?

推荐答案

您需要确保运行 SQL Server 的帐户具有对 'C:\Program Files\Microsoft SQL Server\MSSQL10 的写入权限.SQLEXPRESS\MSSQL\Log，在您确认该目录确实存在之后.

You need to make sure that the account SQL Server is operating under has write permissions to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log, after you've verified that the directory actually exists.

首先进入服务(控制面板/管理工具/服务)并检查 SQL Server 在哪个帐户下运行.可能 NT Service\MSSQL$SQLEXPRESS

First go to Services (Control Panel/Administrative Tools/Services) and check which account SQL Server is running under. Probably NT Service\MSSQL$SQLEXPRESS

然后转到C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL"并右键单击日志"文件夹并单击属性.然后转到安全页面.如果列出了 MSSQL$SQLEXPRESS，请确保它具有完全控制"，如果没有，请单击编辑"按钮并给予它完全控制.如果未列出，请单击编辑"，然后在日志权限"对话框中单击添加并添加 MSSQL$SQLEXPRESS.

Then go to 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL' and right click on the "Log" folder and click properties. Then go to the Security Page. If MSSQL$SQLEXPRESS is listed, ensure that it has "Full Control" if it doesn't, click the "Edit" button and give it full control. If it's not listed, click "Edit" and then on the "Permissions for Log" dialog click add and add MSSQL$SQLEXPRESS.

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