Enabling Remote DAC

Enable remote DAC.

1. Log in to the server:

   Option	Description
   Microsoft SQL Server 2008	"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -U username -P password -S serverName
   Microsoft SQL Server 2012	"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE" -U username -P password -S serverName

   where username, password, and serverName are your user ID, password, and Microsoft SQL Server name.

2. Enable DAC to allow remote connections:

   1> sp_configure 'remote admin connections', 1
   2> go

3. Update the remote admin connections setting:

   1> reconfigure
   2> go

4. Verify the remote admin connections setting:

   1> sp_configure 'remote admin connections'
   2> go

   The result returned should be:

   name                      minimum  maximum  config_value run_value
   ------------------------- -------- -------- ------------ -----------
   remote admin connections  0        1        1            1