In a previous post I spent some time looking at which ports are used by SQL Server 2005 including what port the Dedicated Administrator Connection uses. At the time it looked like it was possible to connect to the DAC for a server without the SQL Browser service running.
Since then as I’ve been studying [...]
There are two modes to the SQL Server 2005 TCP/IP settings; one configuration for all IP addresses or a configuration for each IP address. The mode is governed by the “Listen All” property of the Protocol tab in for the TCP/IP properties, you can get to this via the SQL Server Configuration Manager.
If Listen All [...]
Update: I have posted some more information on connecting to the DAC here.
Playing with ports in SQL Server should be one of the simplest things around. The other day I was studying for the next exam (MCDBA Upgrade) and read this about the ports the server uses…
“If enabled, the default instance of the SQL [...]