SQLServer password problem (original)

xiaoxiao2021-03-06  54

Question 1, modify the system login password, causing the SQLServer to start failed.

Because the SQL Server service is started, a system account is automatically bound, which generally appears to log in to the system outside the Administrator account, because the default SQLServer is not specified.

Solution: Right-click My Computer, Administration, Services, and Applications, "Services", right-click "MSSQLServer", select "Properties", select "Local System Account" or select " Account, and enter a new password.

Question 2, set the SA password, but forgot? How to change? How to change? Old is to forget ...

Workaround: Use the Enterprise Manager to open the server in system account, expand the directory tree "root / security" (Note: Not right-click the root to select the security!), Left click "Login" ", Right-click" SA "selection properties, see" Password "?" ? Enter a new password, enter the new password again in the confirmation window, and determine it.

转载请注明原文地址:https://www.9cbs.com/read-117103.html

New Post(0)