SQL2008 unable to connect to. \sqlexpress, user ' sa ' Login failed (Error 18456) graphic solution

A problem occurred:

Title: Connecting to a server
------------------------------
Unable to connect to. \sqlexpress.
------------------------------
Additional Information:
User ' sa ' login failed. (Microsoft SQL Server, error: 18456)




Workaround:



1. Open the database-log in to the database with Windows identity



02. Login name--double-click SA (Open attribute)



03, general-Set password--ok



04, Status-Login: Enable--OK



05. Right-click the server name--Properties



06. Security--Check SQL Server and Windows authentication Mode--determine

07. Right-click the server name--reboot--Close the database connection, exit the program--log in to the database with SA--to resolve

Additional notes:

If the above method is not valid, then go to the Start menu--microsoft SQL Server 2008--Configuration Tool--microsoft SQL Server 2008

SQL2008 unable to connect to. \sqlexpress, user ' sa ' Login failed (Error 18456) graphic solution