SA0094 : Authentication set to Mixed Mode

Authentication set to Mixed Mode

The rule checks if the SQL Server instance is configured to allow both Windows Authentication and SQL Server Authentication.

Windows Authentication Mode is much more secure than Mixed Mode, and the SQL Server Authentication is provided for backward compatibility only. Whenever possible use Windows Authentication.

Note
Changing this setting will prevent login using SQL Authentication accounts.

Disable SQL Server Authentication and use only Windows Authentication.

The rule has a ContextOnly scope and is applied only on current server and database schema.

Rule has no parameters.

The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.

Maintenance Rules, Security Rules

Choose an Authentication Mode

How to check SQL Server Authentication Mode using T SQL and SSMS

Other Resources