Roger Sohn

If you are backing up an SQL server, it’s advisable to perform a consistency check as part of the backup. When this check fails, it can be hard to work out why, so you can run a check manually. These instructions are for SQL Server 2005.

• Open SQL Management Studio and connect to the SQL server.
• Browse to the database which is reporting consistency check errors
• Ensure the database is highlighted in the Object Explorer pane.
• Click the New Query button.
• In the pane which opens, enter DBCC CHECKDB
• Click Execute (or press F5)
• The check may take a little while to run. The results are displayed in the Messages window.
• If the check completed successfully, the messages should end with CHECKDB found 0 allocation errors and 0 consistency errors in database ‘TestDB’.

Steps to configure WPA on a Cisco Aironet 1100, 1200, 1230, 1240 Series Access Points

Please follow these steps on GUI:

• Open the GUI of the Access Point.
• Go to Security Encryption Manager.
• Select Cipher and choose TKIP from the list.
• Set encryption key 2 as transmit key. (Don’t put any key there)
• Click Apply.
• Select SSID Manager.
• Select SSID and scroll down to “Client Authenticated Key Management”
• Select Key Management to Mandatory and check WPA box.
• Write down the WPA-PSK key
• Scroll down and click Apply.

Commands to enable WPA through CLI:

AP(config)#interface dot11Radio 0

AP(config-if)#encryption mode ciphers tkip

AP(config-if)#ssid ssid_name

AP(config-if-ssid)#authentication open

AP(config-if-ssid)#authentication key-management wpa

AP(config-if-ssid)#wpa-psk ascii pre-shared_key

Please see the following document for further details:

http://www.cisco.com/en/US/products/hw/wireless/ps4570/products_configuration_example09186a00801c40b6.shtml

Q: What are the major security concerns for companies using FTP and Telnet?

A: The main problem with FTP or Telnet is that they are fundamentally insecure protocols. FTP dates back from the 60’s when it was commissioned by DARPA and Telnet was created a bit earlier. That was a time when network security was not as much of a concern as it is today. Both protocols were designed with simplicity, versatility and flexibility in mind, but definitely not security. FTP is primarily used for transferring files between homogeneous or heterogeneous environments while Telnet is the de facto protocol for accessing text-based legacy applications or remotely managing servers and network equipment.

Both FTP and Telnet have many security issues, but the most critical are:

• Clear-text transmission: all communications are done in clear text, including usernames and passwords
• Weak client authentication: both FTP and Telnet authenticate users through usernames and passwords, which, time and time again, have proven to be unreliable authentication methods. There is no support for more advanced authentication methods such as public/private key, Kerberos or digital certificates
• No server authentication: this means that users have no way to be sure that the host they are communicating with really is the FTP server and not an attacker impersonating the server
• Absence of data integrity: problem here is that, assuming the same scenario as above, anyone could alter and corrupt the data being transmitted between the server and the client without being noticed
There are more problems related to FTP and Telnet such as the many exploits available on the Internet or the fact that they don’t play nice with firewalls. Ultimately, these technical problems become critical business challenges which amount to two things: cost of a security breach and lack of compliance with industry standards.

According to a 2007 Forrester study, security breaches cost anywhere between $90 to $305 per record breached. As an example, the breach of a simple text file containing 5,000 names, addresses and social security numbers or credit card numbers would end up costing between $450,000 and $1,525,000. This is the kind of money that businesses can not afford to pay these days, especially when you realize that adequately protecting yourself against simple breaches like FTP or Telnet is going to cost you between 1% and 5% of that amount.

At the end of the day, it’s not about the technicalities of security, it’s about how much you are putting your business at risk by not taking care of basic things such as Telnet or FTP and what price you’ll pay for that.