sql server – Enable Azure SQL DAC (Dedicated Admin Connection)

This page claims that you can connect to Azure SQL with a Dedicated Admin Connection (DAC but not Data-tier Application): learn.microsoft.com/en-us/sql/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver16
The article even goes so far as to specify that you need to connect directly to the database if you’re on Azure SQL.

From SSMS File->New->Database Engine Query, with the “admin:” prefix on the servername, and the specific database, I get “Server was not found or not accessible”.

From sqlcmd -A -S I get “error occurred while obtaining the dedicated administrator connection (DAC) port”

In both cases adding port 1434 to the servername doesn’t change anything.

Since I don’t have sp_configure on Azure SQL, and don’t see any configuration options in the Azure Portal, does anyone know how I can check to see if the DAC is enabled?

There’s a surprising lack of google responses out there on this topic. Has anyone been able to successfully connect to an Azure SQL DAC?

Read more here: Source link