Sample Header Ad - 728x90

How do I log into the Dedicated Admin Console (DAC) on Linux?

4 votes
1 answer
1074 views
[sqlcmd](https://learn.microsoft.com/en-us/sql/tools/sqlcmd-utility) is documented to have, > Login-Related Options > > -A Logs in to SQL Server with a Dedicated Administrator Connection (DAC). This kind of connection is used to troubleshoot a server. This will only work with server computers that support DAC. If DAC is not available, sqlcmd generates an error message and then exits. For more information about DAC, see Diagnostic Connection for Database Administrators. The -A option is not supported with the -G option. When connecting to SQL Database using -A, you must be a SQL server administrator. The DAC is not availble for an Azure Active Directory adminstrator.
Asked by Evan Carroll (65502 rep)
Dec 12, 2017, 07:54 PM
Last activity: Jan 16, 2018, 08:29 PM