You are currently viewing Possible root cause and resolution for ‘Login failed for user ‘####’. Reason: the account is disabled’ error encountered in Sagent

Possible root cause and resolution for ‘Login failed for user ‘####’. Reason: the account is disabled’ error encountered in Sagent

Problem:

When attempting to log onto the Sagent client (Design Studio or Information Studio), access to Sagent is denied and the following error message is displayed:

Error: Login failed for user ‘<login name>’. Reason: the account is disabled. Source: Microsoft OLE DB Provider for SQL Server HRESULT: 0x80004005 Minor Code: 18470 SQL State: 42000 SQL Error Number: 18470

Cause:

The cause of this issue could be the disabled status of the user account mentioned in the SQL Server login specified in the error message. To verify this, you can attempt to log in to ‘SQL Server Management Studio’ (SSMS) using the SA account.

Solution:

To change the SQL server credentials, follow these steps:

  1. Log in to ‘SQL Server Management Studio’ using Windows Authentication.
  2. Go to ‘SQL Server Management Studio’ -> Server -> Security -> Logins -> <Loginname>. In the screenshot below, the disabled login is ‘test’.

kA280000000Cn31CAC_en_US_4_0

  • Right-click on the affected Login (User) and select Properties.
  • In the Login Properties screen, select Status on the left side.
  • Change the Login option from ‘Disabled’ to ‘Enabled’.
kA280000000Cn31CAC_en_US_4_1
  • Navigate to ‘General’ Tab and enter new password
  • Click OK.

To enable the login, the following statement in a query window can also be used:
ALTER LOGIN login_in_name ENABLE;

Leave a Reply