使用Windows& Sql管理工作室登录问题混合模式认证。 [英] Sql management studio login issue using windows & mix mode authentication.

问题描述

我们在登录Sql Management studio时遇到了一个挑战，因为系统所有者离开了组织，我们无法使用Windows身份验证登录到SQL，而且我们没有任何登录凭据可以登录SQL混合模式下的服务器并创建新的SQL用户。如果我们可以解决这个问题，那将是一个很好的帮助..



检查所有在哪里找到这个问题的解决方案..请帮助



谢谢提前..



我尝试过：



尝试了所有可能的方法，试图获得Master DB mdf / ldf附件，但不可能..

We are facing a challenge in login to Sql Management studio, as a System-Owner has left the organisation and we are unable to login to SQL using Windows authentication, along with we do not have any login credentials to login in the SQL server in Mix-Mode and create the NEW SQL user. It will be a great help if we can do workaround for this issue..

Checked all where to find the solution to this issue.. Please help

Thanks is advance..

What I have tried:

Tried all the possible ways, either tried to get the Master DB mdf/ldf attachement, but not possible..

推荐答案

此StackOverflow主题中发布了几个解决方案：

sql - 恢复sa密码 - 堆栈溢出 [ ^ ]



通常的方法是在单用户模式下重新启动SQL Server，以本地Administrators组成员的身份进行连接，并根据需要更改安全性：

灾难恢复：当SQL Server 2005中的SA帐户密码丢失时该怎么办 - Raul Garcia的博客 [ ^ ]

Several solutions posted in this StackOverflow thread:
sql - Recover sa password - Stack Overflow[^]

The usual approach is to restart SQL Server in single user mode, connect as a member of the local Administrators group, and change the security as required:
Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005 – Raul Garcia's blog[^]

拥有安全登录的全部意义在于您无法绕过它们。这是一个功能。



我们遇到了一个问题，我们设法锁定了sa帐号。我们必须以服务器管理员身份登录并使用Windows身份验证。也许这可行？

The entire point of having secure logins is that you can't get around them. This is a feature.

We had an issue where we managed to lock the sa account. We had to log in as the server admin and use windows authentication. Maybe that could work?

这篇关于使用Windows& Sql管理工作室登录问题混合模式认证。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！