This monitor checks for a blank SA password
SQL 2000 SA Blank Password Monitor. Checks if the SA account has a blank password. This monitor is disabled by default.
Use overrides to enabled the SA Blank Password check on selected instances.
Target | Microsoft.SQLServer.2000.DBEngine | ||
Parent Monitor | System.Health.SecurityState | ||
Category | SecurityHealth | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SQLServer.2000.CheckSAPassword | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServer.2000.DBEngine.SAAccountPassword" Accessibility="Public" Enabled="false" Target="SQL2000Core!Microsoft.SQLServer.2000.DBEngine" ParentMonitorID="SystemHealth!System.Health.SecurityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2000.CheckSAPassword" ConfirmDelivery="false">
<Category>SecurityHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2000.DBEngine.SAAccountPassword.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
</AlertSettings>
<OperationalStates>
<OperationalState ID="SAPasswordGood" MonitorTypeStateID="SAPasswordGood" HealthState="Success"/>
<OperationalState ID="SAPasswordBad" MonitorTypeStateID="SAPasswordBad" HealthState="Error"/>
</OperationalStates>
<Configuration>
<IntervalHours>24</IntervalHours>
<ConnectionString>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</ConnectionString>
</Configuration>
</UnitMonitor>