SqlServer Begin's

                             With the new work role, I have the privilege on getting my hands dirty at a OS environment level more frequently. Today I wanted to setup ports for sql related features and found the following to keep on record What ports are currently been used in the current machine - NetStat -0 Identifying what application utilizers a given port - TaskList /FI “PID eq 5304” /FO list /V   Get all the firewall rules - Netsh AdvFirewakk Firewall show rule name = all > c:WFAllRuels:.txt Add a Rule as an inbound rule to access sql server - Netsh AdvFirewall Firewall add rule name =”Sql Server Default 51721” dir=in localport=51721 protocol=tcp action=allow Reference http://technet.microsoft.com/en-us/library/dd734783%28WS.10%29.aspx#BKMK_3_set