I installed a new SQL Server, but it cannot connect with the Dedicated Administrator Connection?
asked Oct 21, 2009 at 01:27 PM in Default
Steve Jones - Editor ♦♦
Are you attempting to connect from the local server, or a remote machine? Using SQLCMD or SSMS?
Here are a few things to keep in mind when working with the Dedicated Administrator Connection (DAC):
Verify the account you are connecting with is a SysAdmin on the SQL Server. The DAC is only available to members of the SysAdmin server role.
By default, the DAC is only available on the local server. If you are trying to connect from a remote machine, you will need to enable network connections:
If you are using SQLCMD, be sure to use the -A switch to access a DAC. If you are using SSMS, be sure to prepend "ADMIN:" to your server name.
Here is a brief overview from MS
answered Oct 21, 2009 at 01:52 PM
See the following links for information on using the dedicated administrator connection:
answered Oct 21, 2009 at 01:50 PM