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

11 December,2012 by Tom Collins

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

Error_18470

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


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Server - Error 18470 : Login failed for user. The account is disabled


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer