search cancel

Receive: 'Warning: mssqlsrvdown: <hostname>: 0.00' and '[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. (18456)'


Article ID: 49158


Updated On:


CA Capacity Manager CA Distributed Database Management CA Database Analyzer for DB2 for Oracle



SQL Server Status it is displaying the following message in the overview tab of the Performance Summary

    'Warning: mssqlsrvdown: <hostname>: 0.00'

No data is returned to the scans for this agent. The agent log uv_ms_prompted log display the following message:

 [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. (18456)
[01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)

How to resolve this error?


This error can occur if you selected the 'OS Authentication' option during the Knowledge Agent Configuration. Follow these steps to rectify this:

  1. Go to Performance Summary screen and stop the ms2008 Insight Agent.
  2. Remove this ms2008 Insight Agent by clicking on the trash can icon.
  3. Go to 'DCC Configuration' --> click on 'Knowledge Agent Configuration' --> select 'Microsoft SQL Server 2008' and click 'Next'--> select the Server, do not select the 'OS authentication' option and proceed to complete the Knowledge agent configuration.


Component: UNIDCC