Database authorizations differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the authorizations between the two servers in any databases. This could be e.g. system databases.

To query the Performance Store database for differences in authorizations between two databases, use:

exec dbo.s_database_authorizations_diff '[server 1]', '[server 2]'

Authorizations can be synchronized between servers by executing the “create_statement” from the dbo.v_authorizations view.

A script for synchronizing authorizations between a primary and secondary can automatically be created. See Synchronize Availability Group objects for more information.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.