Connecting to SQL Server through a DAC

As early as you know, you can connect to SQL Server by using a dedicated administrator connection, but it has not been successfully connected. Seeing this again today, I want to try again.

1. Enter ADMIN:GGG in the server name in the "Connect to Server Dialog" in SSMs and click Connect, but pop up a box to error: Private administrator connections are not supported.

2. Open the SQL Server Browser service, and then connect again, or report the same error.

3. Open the remote admin connections option in the server configuration:

sp_configure ' show advanced options ', 1goreconfiguregosp_configure ' remote admin connections ', 1goreconfiguregoselect * From Sys.configurationswhere name = ' Remote admin connections '

4, and then, on the Internet to check the information, but also the same problem, but see the mention through the command line to connect, and then tried, succeeded:

C:\users\ggg>sqlcmd-a1> SELECT @ @spid2 > go------    54 (1 rows affected) 1>

5, but through SSMS in the beginning of the login box, or no way to log in, so continue to find on the Internet, found that there is a way, through SSMs, menu: File----> New----> Database engine query, input ADMIN:GGG, you can:

6. Verification

Run the following code:

Select E.name,          --endpoint name       s.session_id,       s.program_name,       e.protocol_desc,       s.host_namefrom Sys.endpoints Einner Join sys.dm_exec_sessions s on        e.endpoint_id = S.endpoint_idwhere E.is_admin_endpoint = 1