Generally refers to the use of SQL Server password authentication mode, the sa or admin user password forget. First, open the Registry Editor,“run”, enter regedit find[HKEY_LOCAL_MACHINE\\SOFTWARE\\MICROSOFT\\MSSQLSERVER\\MSSQLSERVER], This item which has a key value LoginMode, now the value is 1, Change the value to 2, reboot the computer; Open Enterprise Manager, right-select“Edit SQL Server registration Properties”, select“Use Windows Authentication”, the point is determined, it can be connected on the database server. In this case by“Security to on login”you can modify the sa or admin user's password; Again open the Registry Editor,“run”, enter regedit find[HKEY_LOCAL_MACHINE\\SOFTWARE\\MICROSOFT\\MSSQLSERVER\\MSSQLSERVER] the LoginMode value to 2, reboot the computer; Open Enterprise Manager, right-select“Edit SQL Server registration Properties”, select“Use SQL Server Authentication”, enter the corresponding administrator username and password, you can connect to the database server.
Butler woman administrator password PJ: the There are a lot of Butler po accounting software the user had forgotten the administrator password of the phenomenon, so what to do? Is direct the software to reload or change a Ledger sets? In fact, it doesn't matter, there are still ways you can get back to, the following I will introduce how to retrieve password: 1, open sql Enterprise Manager, in the console under the root directory and then click Open, find the“database” - your Butler po database under the name of“table” 2, in the right side find“employee”,right-select“Open table”--“return all rows”, to remember the user name corresponding to the“typeID” 3, the same open“loginuser”, the etypeID corresponding to the password is password More than in the Butler woman apparel and footwear industry version 8. 1 6 9, brilliant 2 0 0 8++and apparel 2 0 0 8+tested are effective
So protect your sql sa rights the password is the real protection ---- And speed up, like, speed up to 3 0 0 0 the password in the operator table, the financial and 5 0 0 0 in m_operator table. Are plaintext. Much better to use SQL database software can see!