sqlserver probe login failed: The password of the account must be changed

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When we try to connect the UIM sqlserver probe to our SQL Server DB the connection fails with the following error:

IM GUI and AC: 

 

Mar  2 10:48:42:728 [12824] sqlserver: Profile: test connection profile/test connection checkpoint/Connect - COM Error: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user'.  Reason: The password of the account must be changed.  

 

Environment

Release : UIM 20.x

Probe: sqlserver any version

Cause

MS SQL User Password Requirement: Login failed for user 'dd_user'. Reason: The password of the account must be changed. (Microsoft site)

The user used in the probe to connect to the DB has a password enforcement policy: "User must change password at next login"

Resolution

Change the password restriction policy or log into SQLServer Management studio, update the password policy, or update the password and try again.