Name: Instance Authentication Mode
Platform: Sqlserver
Category: Security
Premium package: Security and compliance package
Description: Checks if the Server Authentication property is set to ‘Windows Authentication Mode’ or ‘Mixed Mode’ authentication.
Long description: Checks if the Server Authentication property is set to ‘Windows Authentication Mode’ or ‘Mixed Mode’ authentication.
Version: 1.2
Default schedule: 14 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) if “Windows Authentication Mode” is not in use.
history threshold 365 The maximum number of days to keep statistics for in the historic tables.

← Database backup (2005-2012) / Guest database users →

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