SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE

SQL SERVER - Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE DBCC-FLUSHAUTHCACHE-800x812 A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. Before you read this blog post, let me clarify that this DBCC function only applies to Azure SQL Database.

Essentially, DBCC FLUSHAUTHCACHE empties the database authentication cache containing details about logins and firewalls. This is not applicable for the on-premises databases or stand-alone SQL Server installation.

This is required in the Azure SQL Database because in Azure when a password is reset in SQL Database, the connection won’t be unauthenticated. However, in the case of the on-premises database, if the password has changed since the connection was initially authorized, the connection must be terminated and a new connection made using the new password.

If you want to remove the cache in Azure which saves details about the password, you can run the following command.

DBCC FLUSHAUTHCACHE; 

Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the Last 5 SQL in Sixty Seconds Video.

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Menu
Exit mobile version