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

2 comments:

  1. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    http://chennaitraining.in/sap-rem-training-in-chennai/
    http://chennaitraining.in/sap-scm-training-in-chennai/
    http://chennaitraining.in/sap-sd-training-in-chennai/
    http://chennaitraining.in/sap-sm-training-in-chennai/
    http://chennaitraining.in/sap-srm-training-in-chennai/
    http://chennaitraining.in/sap-success-factor-training-in-chennai/
    http://chennaitraining.in/sap-tr-training-in-chennai/
    http://chennaitraining.in/sap-wf-training-in-chennai/

    ReplyDelete

  2. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
    Msbi online training Hyderabad
    Msbi online training India
    Msbi online course
    Msbi course
    Msbi training
    Msbi certification training

    ReplyDelete