SQL Server provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.. GeoPITS brings you the comprehensive details of Dedicated admin connection's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | Yes1 | Yes1 |
| Version v2017 | Yes | Yes | Yes | Yes with trace flag | Yes with trace flag |
| Version v2016 | Yes | Yes | Yes | Yes with trace flag | Yes with trace flag |
| Version v2014 | |||||
| Version v2012 | under trace flag | under trace flag |
SQL Server provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.
You can find more details about this version here
Back to all features