none
TITLE: Connect to Server ------------------------------ Cannot connect to ABHI-PC\SQLEXPRES. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'abhi-PC\abhi'. Reason: The account is disabled. (Microsoft SQL Server, Error: 184 RRS feed

  • Question

  • TITLE: Connect to Server ------------------------------  Cannot connect to ABHI-PC\SQLEXPRES.  ------------------------------ ADDITIONAL INFORMATION:  Login failed for user 'abhi-PC\abhi'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
    • Moved by Bob Beauchemin Saturday, May 14, 2016 3:26 PM Moved to client-side SqlClient forum for best results
    Saturday, May 14, 2016 8:35 AM

Answers

  • Hi Ach Ashraf,

    According to your description, it seems that the particular user Login is Disabled. please try to refer the following steps and check if it works for you.

    1. Expand the Instance of SQL Server

    2. Expand Security node

    3. Select the Particular Login (User)

    4. Press right button and select properties of the login

    5. Go to Status table Enble the User

    In addition, you could also  use T-SQL to enable the use, as below:

    Use master
      go
        Alter Login UserName Enable
      go
    

    For more information, please see:

    https://msdn.microsoft.com/en-us/library/ms189828.aspx?f=255&MSPPError=-2147217396

    Best regards,

    Cole Wu


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, May 16, 2016 1:52 AM
    Moderator

All replies