Name: Renamed sa account
Platform: Sqlserver
Category: Security
Premium package: Security and compliance package
Description: Checks if the standard ‘sa’ login account (principal_id=1 and sid=0×01) has been renamed.
Long description: Checks if the standard ‘sa’ login account (principal_id=1 and sid=0×01) has been renamed. ‘sa’ is the original login account created during installation, and with sysadmin privileges.
Version: 1.2
Default schedule: 25 1 1 *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)
Parameters
Name Default value Description
return status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when the “sa” login account is not renamed.
new login name change_me If parameter “rename sa login” is set to “YES” the alert will rename “sa” login account to this parameter value.
rename sa login NO If set to “YES” the alert will rename “sa” login account using “new login name” parameter value.
history threshold 365 The maximum number of days to keep statistics for in the historic tables.

← Windows LOCAL groups / Remote admin connections →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment