Skip to main content
How can we help?
< All Topics
Print

Database security differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the database security between the two servers. Even though databases are synchronized, there might still be differences in the security in the system databases.

To query the Performance Store database for database security differences between two servers, use:

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

Users can be synchronized between servers by executing the “create_statement” from the dbo.v_database_security view.

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

Note, this is different from “Database securables differences” that shows differences in grants, permissions, etc.

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.

Table of Contents