Azure SQL Database - dedicated administrator connection (DAC)

2 votes

1 answer

270 views

                          If you check the setting in any of your Azure SQL databases, you will see that the value_in_use column value is zero for Remote admin connections. Meaning ‘Remote admin connections’ are not allowed from remote clients. There is no way to change that at the time of writing this question. sp_configure is not available for Azure SQL Database.

    SELECT * FROM sys.configurations
    WHERE NAME = 'remote admin connections'
    ORDER BY NAME;
Does that mean Remote admin connections are not allowed for Azure SQL Databases? 
                        

Asked by SqlWorldWide (13707 rep)

Mar 13, 2021, 11:24 AM

Azure SQL Database - dedicated administrator connection (DAC)

Related Questions