Login to Microsoft SQL Server Error: 18456

Total Post:106

Points:748
 333  View(s)
Ratings:
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. Post:140

    Points:984
    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 : 

    https://www.youtube.com/watch?v=aU8RhjdkCoE

    Happy Coding :)

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!