Re: Encryption

From: Neil Pike (neilpike@compuserve.com)
Date: 04/24/03 

Date: Wed, 23 Apr 2003 23:19:38 +0100
From: Neil Pike <neilpike@compuserve.com>

 Sandy,
 
 He wants solid docs saying that SQL Server can't encrypt a database? Well
there isn't any. Just like there isn't any saying that SQL Server will mow my
lawn, or paint my fence, or solve poverty (or anything else it doesn't do)....
There are only docs on what a product DOES do, not what it DOESN'T....
 
> Sorry Neil for taking so long to respond. I've tried to find where
> Microsoft SQL states that it can encrypt a database and couldn't. I
> guess I was mistaken when reading their documentation. Although I have
> had conversations with my lead developer and for some reason he thinks
> SQL 2000 can encrypt the database. I told him that I have been
> communicating with some people that say it cannot and that using the
> operating system’s EFS can do it. Well now he wants solid documentation
> stating so. Could you please direct me to where I could get that info?
> I would certainly appreciate it!!

 Neil Pike MVP/MCSE. Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)