How to connect to SQL Server using DAC via SQL Server Management Studio and how to connect to SQL Server using DAC via SQLCMD. It also provides the resolution to the errors below:
1- Dedicated Administrator connection are NOT supported via SSMS as it establishes multiple connection by design
2- Connection was established successfully and then failed during handshake.
It also demonstrates how to force connection to use TCP/IP protocol as well as how to enable and disable Named Pipe protocol in SQL Server.
Below are the DAC commands used in this video:
admin:DynamicsAXDev\SQLTEST --SSMS connection
sqlcmd -S admin:DynamicsAXDev\SQLTEST