Obtaining the Microsoft SQL Server DAC Port Number

Obtain the Microsoft SQL Server DAC port number.

1. Open the ERRORLOG file in a text editor. This file is located in the log directory of your Microsoft SQL Server. For example:

   C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2. Search for the string "Dedicated admin" to find an entry similar to this:

   2007-11-09 13:40:02.40 Server Dedicated admin

   connection support was established for listening

   locally on port 1348.

3. Record the port number specified in this entry for use in a later step.