data_engine not connecting to database - COM Error [0x80004005] Unspecified error - Microsoft SQL Server Native Client 11.0 0 - is not able to access the database under the current security context.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The data_engine probe worked fine and stopped working all of a sudden. The data_engine probe fails to start and is not able to connect to the database

data_engine.log:

Login failed for user 'UIM_Adm'. .. COM Error [0x80004005] Unspecified error - [Microsoft SQL Server Native Client 11.0] Cannot open database "<db name>" requested by the login. The login failed. 

[Microsoft SQL Server Native Client 11.0] The server principal "<db user>" is not able to access the database "<db name>" under the current security context.

Environment

Any UIM version

Cause

db_owner database role was removed for the data_engine database SQL user

Resolution

Engage the MS SQL Server Admin and validate that db_owner database role has not been removed for the "<db user>" SQL server account