我的Windows身份验证用户已被禁用(My Windows Authentication user has been disabled)

我的Windows身份验证用户已被禁用(My Windows Authentication user has been disabled)

我意外地禁用了我的Windows Authentication登录，但我没有登录（或其他管理员登录）。

我如何登录sql server 2008？

I accidently disabled my Windows Authentication login and I don't have sa login (or other admin login).

How I can login to sql server 2008?

最满意答案

请执行以下操作： 故障排除：系统管理员被锁定时连接到SQL Server ：

解析度

使用-m或-f选项以单用户模式启动SQL Server实例。 然后，计算机的本地Administrators组的任何成员都可以作为sysadmin固定服务器角色的成员连接到SQL Server实例。

Follow this: Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out:

Resolution

Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.