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

Document ID : KB000049158
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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?

Solution:

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.