Thursday, February 28, 2008
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 [...]
Monday, February 25, 2008
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 [...]