SQL Server password Problems

SQL Server password Problems

 

Problem 1: The system logon password is modified, causing sqlserver startup failure.

This is because the sqlserver service is automatically bound to a system account when it is started. This usually happens when a system account other than the Administrator account is logged on to the system, because sqlserver does not specify an account by default.

Solution: Right-click "my computer", "manage", and "service and application"Program"," Service ", right-click" MSSQLServer ", select" properties ", and select" Local SYSTEM account"OrSelect "this account" and enter a new password.

Question 2: Why did I forget the SA password? How to change it? How to change it? Always Forget ...... Alas

Solution: Use the Enterprise Manager to open the server as a system account and expand the directory tree "root/Security" in sequence"(Note:No, right-click root and choose security in "properties !)Left-click "Log on", right-click "sa", and select Properties. Is the "password" displayed ?? Enter a new password. In the confirmation window, enter the new password again. OK.