SQL2008 user ' sa ' Login failed (Error 18456) graphic solution
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
|
SQL Server user ' sa ' Logon failure (Error 18456) graphic solution