Reproduced in: http://thenear.blog.51cto.com/4686262/865544
User ' sa ' Login failed (Error 18456) solution plot when we use SQL Server, we may encounter such error "Unable to connect to., user ' sa ' Login failed (Error 18456)",
Specific solutions:
- First open SQL Server as an administrator and enter as a Windows identity.
- Then open "Security"--"login name" to find the user "SA" to open its properties panel.
- Next, select "General" to set the password, and click "OK" to save.
- Then select "Status"--login is set to "Enabled" and click "OK" to save.
- Then open the SQL Server Properties page action is "Select Server Right-click-Properties", select "Security" to select the server authentication as "SQL Server and Windows authentication mode (s)", click "OK" to save.
- Finally, right-click on the server and select "Restart (A)" To restart the server is OK.
If the above approach is still unable to resolve the operation of a second:Open Start Menu--Microsoft SQL Server 2008--Configuration Tools--Microsoft SQL Server 2008 Select SQL Server network configuration to Named pipes state "Tcp\ IP status "All modified to Enabled" After you complete these actions, your problem is resolved.
This article is from the "one year Later" blog, please be sure to keep this source http://thenear.blog.51cto.com/4686262/865544
SQL Server user ' sa ' Logon failure (Error 18456)