SAP Knowledge Base Article - Preview

3475338 - Solution Manager - MSSQL Database Not Available alert

Symptom

In Solution Manager System Monitoring there is a Windows host alert for MSSQL Database Not Available caused by the metric : MSSQL Server Software Status

returning the following text: The SQL login NT AUTHORITY\SYSTEM does not have sufficient permissions. Please grant the sysadmin server role to NT AUTHORITY\SYSTEM

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental


Read more...

Environment

  • SAP Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

MSSQL Database Not Available, MSSQL Server Software Status, The SQL login NT AUTHORITY\SYSTEM does not have sufficient permissions, Please grant the sysadmin server role to NT AUTHORITY\SYSTEM , KBA , SV-SMG-MON-ALR , Monitoring/Alerting/Reporting Infrastructure , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.