Check for Telnet <ServerName> <PortNumber> , it should be open.(Scree will go blank)
Regards
Chandan Gupta

I also followed the steps by Gila, It works, TranslogFile usage comes from 67GB with 89%of usage to 1GB with 0.02% of usage, SUCH a BIG WOW.
Hatts off to...

SQL Server 2008 R2 is the latest release of Microsoft SQL Server. The “R2” tag indicates this is an intermediate release of SQL Server and not a major revision. There...

1.Transparent Data Encryption. The ability to encrypt an entire database.

2.Backup Encryption. Executed at backup time to prevent tampering.

3.External Key Management. Storing Keys separate from the data.

4.Auditing. Monitoring of data access.

5.Data...