由于登录失败，SQL Server 2012无法启动 [英] SQL Server 2012 can't start because of a login failure

问题描述

我最近在全新的Windows 7安装上安装了Microsoft SQL Server 2012，但是每当我要运行服务器时，都会出现以下错误:

I recently installed Microsoft SQL Server 2012 on a fresh Windows 7 installation, but whenever I want to run the server, I get the following error:

错误1069:由于登录失败，服务未启动.

Error 1069: The service did not start due to a logon failure.

以下用户被配置为启动服务:NT Service\MSSQL$SQLEXPRESS

The following user is configured to start the service: NT Service\MSSQL$SQLEXPRESS

如何解决此问题?

推荐答案

答案可能与SQL Server完全启动(NTService \ MSSQLSERVER)问题相同，这是重置密码.具有讽刺意味的是，没有密码.

The answer to this may be identical to the problem with full blown SQL Server (NTService\MSSQLSERVER) and this is to reset the password. The ironic thing is, there is no password.

步骤是:

• 右键单击Services mmc中的服务
• 点击属性
• 单击登录"选项卡
• 密码字段中似乎包含条目...
• 空白两个密码字段
• 点击确定"

这应该重新授予对该服务的访问权限，并且应该重新启动.奇怪吗?

This should re-grant access to the service and it should start up again. Weird?

注意:如果问题在几个小时或几天后再次出现，则您可能具有一个组策略，该组策略将覆盖您的设置，并且该策略即将到来并立即消失.

NOTE: if the problem comes back after a few hours or days, then you probably have a group policy which is overriding your settings and it's coming and taking the right away again.

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