由于登录失败，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 ServiceMSSQL$SQLEXPRESS

The following user is configured to start the service: NT ServiceMSSQL$SQLEXPRESS

我该如何解决这个问题?

How can I fix this problem?

推荐答案

此问题的答案可能与完全成熟的 SQL Server (NTServiceMSSQLSERVER) 的问题相同，即重置密码.讽刺的是，没有密码.

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

步骤是:

• 在服务 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屋！