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