Error Message 3149 When Adding Domain Account

book

Article ID: 210861

calendar_today

Updated On:

Products

DX Infrastructure Management CA Unified Infrastructure Management for z Systems CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Client created a domain account with sysadmin permission, but data_engine logs shows an error.

See below errors found from logs:

Contacting data_engine probe...
Executed async test_connection on //data_engine, please wait...
Waiting...
test connection DONE - result: 
Connected: no
Ping: no
DB Version: n/a
data_engine schema version: n/a
COM Error [0x80040e4d] IDispatch error #3149 - [Microsoft SQL Server Native Client 11.0] Login failed for user 'jkjk'.(1)

Cause

Missing parameters in database engine configuration

Environment

Release UIM: 20.3

Component : UIM - DATA_ENGINE

Windows 2016

MSSQL 2016/2017 Database

Resolution

1. Deactivate data_engine.

2. Open the data_engine configuration and go to the "Database" tab.

3. Add to Parameters: Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI 

4. Activate data_engine.