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

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 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 -Sadmin:DynamicsAXDev\SQLTEST
sqlcmd -S admin:DynamicsAXDev\SQLTEST


What is DAC in SQL Server and How to use DAC - SQL Server Tutorial

No comments:

Post a Comment