sql server登录问题 [英] sql server login Problem

问题描述

您好

我的sql server windows身份验证用户已停用

我忘了sa密码

我没有其他用户

我该怎么办？

Hi There
My sql server windows authentication User is disabled
and I forgot the sa password
and I dont have other users
What should I do?

推荐答案

试试这个程序：http://v-consult.be/2011/05/26/recover-sa-password -microsoft-sql-server-2008-r2 / [ ^ ]



也可以查看：http://www.mssqltips.com/sqlservertip/1441/correct- -sql-server-authentication-mode-in-the-windows-registry / [ ^ ]

Try this procedure: http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/[^]

Check out this too: http://www.mssqltips.com/sqlservertip/1441/correct-the-sql-server-authentication-mode-in-the-windows-registry/[^]

您好这将对您有所帮助。



1）转到开始菜单

2）转到SqlServer 2005

3）SqlServer配置管理器

4）你会看到SqlServer服务.... Cick on it

5）在右侧你会看到SqlServer（MS SqlServer）如果它正在运行右键单击并再次停止RC并转到属性

6）转到启动参数--- - 查看位置

7）启动SQL服务。这些现在在单用户模式下运行。

8）转到开始菜单类型CMD

9）c：\ Users \Administrators> sqlcmd



CREATE LOGIN恢复WITH PASSWORD ='TopSecret 1'（记住SQL服务器有默认的强密码策略

Hello This will help you.

1)Go to start Menu
2)Go to SqlServer 2005
3)SqlServer Configuration Manager
4)You will see SqlServer Services.... Cick on it
5)at the right side you will see SqlServer (MS SqlServer) if its running Right click and Stop this again RC and go to properties
6)go to Startup Parameters-----see the location
7)Start the SQL services. These are now running in Single User Mode.
8)go to Start menu type CMD
9)c:\Users\Administrators>sqlcmd

CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ (Remember SQL server has default strong password policy

这篇关于sql server登录问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！