我意外地禁用了我的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.
更多推荐
发布评论