SQL Server DBA Tutorial 139-What is DAC in SQL Server and how to use DAC

In this video you will learn: What is DAC in SQL Server? 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 visa SSMS as it establishes multiple connection by design 2- Connection was established successfully and then failed during handshake. It also demonstorates 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 -Sadmin:DynamicsAXDev\SQLTEST sqlcmd -S admin:DynamicsAXDev\SQLTEST Blog post link for the video: http://sqlage.blogspot.com/2015/03/what-is-dac-in-sql-server-and-how-to.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html