SQL Server Agent fails connecting to the database

Troubleshooting

Problem

When the ITM MSSQL Server Agent is started, it fails connecting the monitored database and as a consequence no data is retrieved, TEP views are empty.

Symptom

The collector log file (<hostname>_OQ_<instance>_col.out) shows the following messages:
**********
MSU0500I (2015-02-14 09:48:52) (1452)SQLSTATE: 08001, Native error: 17,
Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
MSU0500I (2015-02-14 09:48:52) (1452)SQLSTATE: 01000, Native error: 53,
Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
MSU0425E (2015-02-14 09:48:52) (1452)Database open failed. Server:MV-PLMDB User:<user>.
SRVE107E (2015-02-14 09:48:52) KOQSQLD(4068) (1452)Could not connect to MS SQL Server
********

[{"Product":{"code":"SSDKXQ","label":"Tivoli Composite Application Manager for Microsoft Applications"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Microsoft SQL Server Agent - 5724B96MO","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.3.0","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
Tivoli Composite Application Manager for Microsoft Applications

Software version:
6.3.0

Operating system(s):
Windows

Document number:
727443

Modified date:
30 January 2019

UID

swg21697964

IBM Support

Tips