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
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.