How To Fix Login Failed for User Microsoft SQL Server Error 18456 Step-By-Step

Sign in to queue

The Discussion

  • User profile image

    from login - properties - securable --> mark the permission for ( control server )
    this solve the error ISA

  • User profile image

    Right click server name from the SSMS and go to server properties. Click security and enable Wndows and SQL Server Authentication mode. This solution is to the point and will fix the problem.

  • User profile image

    Thank you matay ! I did that before on my local PC but I forgot completely.

  • User profile image

    Thanks matay. Been a awhile since I set up a new db server.

  • User profile image

    If this helped, Please rate using stars above.


  • User profile image

    Nah, mate its a no go with this method.

  • User profile image

    Just an update, here is the solution if anyone else has there error with a properly configured login:

    If you're trying to connect using "SQL Server Authentication" then you may want to modify your server authentication:

    Within the Microsoft SQL Server Management Studio in the object explorer:

    Right click on the server and click Properties

    Go to the Security page

    Under Server authentication choose the SQL Server and Windows Authentication mode radio button

    Click OK

    Restart SQL Services

Add Your 2 Cents