So, follow these steps to reset <2008 data-blogger-escaped-password="password" data-blogger-escaped-strong="strong"> </> for SA account if no builtin Administrator.
Step 1 Download and install MS SQL Server Password Unlocker. Step two. Running MS SQL Server Password Unlocker, click Open, master.mdf file import. Displays all the user name of your SQL Server.
Step 3 Select the SQL account, such as 'IN', click the Change Password button.
Step 4 Enter a new password, and then click OK.
new password for the account is set ON, you can now login to the SQL Server using the new password.
Mixed Mode - SQL Server and Windows Authentication Mode
SQL Server 2005 introduces a new method, the password policy and account lockout policy session of SQL Server using SQL Server authentication implemented. SQL Server 2008 also to do so. Politics SQL Server can use the password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and became a major security risk to most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practices for managing authentication in the past. Now, SQL Server and Windows Authentication mode can successfully compete with Windows Authentication mode.
How to reset the SA password in SQL Server 2008, when he had forgotten the SA password? This article provides an easy way for SQL 2008 Password reset.
0 comments:
Post a Comment