SQL Server-2005 Windows身份验证已禁用. [英] SQL Server-2005 Windows Authentication Disabled.

问题描述

先生... !!!

我在Windows身份验证模式下安装了SQL Server-2005.

但是我的Windows身份验证帐户已禁用.我无法登录.

一个我不知道的帐户密码.有机会登录而不是重新登录吗?

请帮帮我....

在此先感谢... !!!!

HI Sir...!!!

I installed SQL server-2005 in windows authentication mode.

But my windows authentication account is disabled. im unable to login.

sa account password i dont know. is there any chance to login rather than reinstal???

Please help me out....

Thanks In Advance...!!!!

推荐答案

如果最初安装的是SQL Server，则只需重新安装即可.如果您不拥有所涉及的服务器实例，则可能需要找到执行该操作的人员，并让他们打开身份验证或提供您可以使用的sql登录.

If you installed SQL Server initially, then just reinstall it. If you do not own the server instance in question, then you may need to find the person who does and get them to either turn on the authentication or give you a sql logon that you can use.

如果SQL Server仅使用Windows身份验证，则无法使用SA登录，因为该帐户未处于活动状态.为什么不只使用另一个管理用户(计算机中本地管理员的成员)来使用它来连接和更改SA密码.

重新安装也是完全有效的选择.以及其他可能的方式: http://blog. sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/ [

If the SQL Server is using windows authentication only, you cannot use SA to login since the account isn''t active. Why not just use another administrative user (a member of local admins in the computer) and use that to connect and change the SA password.

Reinstall is also a perfectly valid option. And other possible ways: http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/[^]

这篇关于SQL Server-2005 Windows身份验证已禁用.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！