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

Sign in to queue

The Discussion

  • User profile image
    ahmed

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

  • User profile image
    matay

    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
    jun

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

  • User profile image
    raps

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

Add Your 2 Cents