Login to Microsoft SQL Server Error: 18456

Total Post:106


 621  View(s)
Rate this:

I am getting following error while trying to connect to the SQL Server 2017.

Login to Microsoft SQL Server Error: 18456

Please let me know how to fix this issue.

  1. Re: Login to Microsoft SQL Server Error: 18456

    When logging into SQL Server and entered invalid credentials than The message Login Failed for User  (Microsoft SQL Server, Error: 18456) occurred .  

    Administrative permissions to connect to the server not for Microsoft SQL Server Management with a user. 

    follow these steps to fix your problem:

    1-Right click on the server and click Properties follows 

    2-Go to the Security page which you want to access 

    3-Under Server authentication choose the SQL Server and Windows Authentication mode radio button for select your choice .

    4-Click OK choice of message shown in window 

    5-Restart SQL Services and wait to fix your problems. 

    This is video link for a short video on fix your problem on youtube : 


    Happy Coding :)

      Modified On Jun-11-2018 11:05:48 PM


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.