Enabling Remote DAC

Enable remote DAC.

Prerequisites

Task

Log in to the server:
```
"C:\Program Files\Microsoft SQL Server\90\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.
Change the Microsoft SQL Server remote admin connections configuration option to enable DAC to allow remote connections:
```
1> sp_configure 'remote admin connections', 1
2> go
```
Update the remote admin connections setting:
```
1> reconfigure
2> go
```

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