- Open SSMS.
- In object explorer, connect to the SQL Server instance that you want to enable DAC.
- Right click on Server instance and select Facets.
- In View Facets window selectServer Configuration using the drop down box. See below figure:
SELECT CASE WHEN ses.session_
FROM sys.endpoints AS en
ON en.endpoint_id = s
WHERE en.NAME = 'Dedicated
If your using the server name when connecting, make sure SQL Server Browser service is running. Otherwise you will receive the most common log on error which is "A Network-related or instance-specific error occurred…" which basically says it cannot find the server.
It is always a good practice to enable