SQL Server user ' sa ' Logon failure (Error 18456)

Source: Internet
Author: User
Tags microsoft sql server

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:
    1. First open SQL Server as an administrator and enter as a Windows identity.
    2. Then open "Security"--"login name" to find the user "SA" to open its properties panel.


    3. Next, select "General" to set the password, and click "OK" to save.


    4. Then select "Status"--login is set to "Enabled" and click "OK" to save.


    5. 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.


    6. 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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.