DAC connection is used to SQL Server when you are not able to connect SQL Server.
Only one DAC connection is allowed for SQL Server instance.
- Open the SQL Server Management Studio as Administrator
- Click on “Database Engine Query” (icon next to New Query) on the toolbar.
- In the “Server Name” box enter the server name in the following formatADMIN:local
- Connect the server and execute the required commands.
For more details check the technet article.
No comments:
Post a Comment