tags: apache   archive   business   charity   climbing   comic   communication   database   email   exchange   family   fm2008   hack   hardware   humour   linux   liverpool   microsoft   money   mysql   network   oes   opensource   outlook   php   pictures   process   project   quote   real_life   review   rss   science   security   software   thought   tsm   updates   webdev   website   windows  

Open your ears

Sun, 09 Sep 2007 06:09:30

Yesterday I was working on an SQL cluster and part of the job was to change the IP address. Doing so caused the application dependent on the cluster to fail. I was required to make a registry changes so the SQL server would listen on the new IP address. What helped me determine the issues and resolve it quickly was running 'netstat -a -n' from the command prompt and looking at what IP address the SQL server was listening on. 'netstat -a -n' is a handy command worth running on secure servers as part of a schedule so you can view what ports/services your server is open to.

Cheers
Ryan Partington