Re: Encrypt/Decrypt SQL Server 2005 data files

Hi Joe,

Thank you very much for the reply. EFS is what we tried. There are two unfortunate limitations. First, according to Microsoft, you cannot use SQL if the log file is encrypted. Second, decrypt takes many minutes and the long required time makes the technology impractical to use.
I agree that there is no absolute way to prevent access to data once an expert has physical possession of a computer or a hard drive.
SecuriKey does work as advertised. There are ways to circumvent the technology, but it provides some protection.

Robbie
.

Relevant Pages

  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... the newsgroups are staffed weekdays by Microsoft Support professionals to ... server since Exchange server has intalled on the box. ... However if you want to configure SQL to send mail you need to install ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Solution to do Accent Insensitive Full Text Search with SQL Server 2000
    ... Also note that SQL 2005 does support accent insensitive searching. ... Looking for a SQL Server replication book? ... Installing an accent insensitive version of Microsoft Search ... This is the installation program we will use to ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Migration to SQL 2005 for Workgroups
    ... First I just want to list the detailed upgrade steps for your reference, ... sharepoint will use SQL 2005 instance indeed. ... different mechanism from Microsoft NTBackup to backup Server. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: [Full-Disclosure] FW: VERITAS Software Technical Advisory
    ... SQL Server/MSDE-Based Applications ... Altris/Spescom Deployment Server Altris http://www.altris.com Unknown ... Biztalk Server 2002 Partner Edition Microsoft ...
    (Full-Disclosure)