Chuyên mục: Database

Recover a lost SA password

In this article, we will review how to recover SA password by starting SQL Server in single user mode when you forget “sa” credentials or lose the access to the instances due to the following reasons:

  • You configured a new SQL Server instance and lost or forgot the “sa” password
  • All the users who are part of sysadmin server level role are removed accidentally
  • All the users who are part of sysadmin server level role are disabled accidentally
  • Lost sysadmin access to the SQL Server instance

Consider this scenario:

Đọc tiếp “Recover a lost SA password”