SQL Server - Error 18470 : Login failed for user. The account is disabled

A user reported the error 18470 – when attempting to login to a SQL Server Instance

 Login failed for user ‘testLogin’. Reason the account is disabled

They were logging on using SSMS , returning a   pop up window similar to the below. They requested the DBA to investigate the error message

To check the current status of the Login use this query to establish whether enabled or disabled. The query is on the sys.server_principals, which contains a row for every server level principal.

select name,is_disabled from sys.server_principals where name = ''
--is_disabled
--1 = Login disabled
--0 = Login enabled

--Use   ALTER LOGIN command to enable the login account

ALTER LOGIN [testLogin] ENABLE

 Read More

sp_password and ALTER LOGIN - SQL Server DBA

ALTER AUTHORIZATION sql to change owner of a - SQL Server DBA

SQL Server - List all SQL Server users - SQL Server DBA