Re: MSDE 2005 encryption

SQL Server Express does include Service Broker, but there are some licensing limitations to its use.

Dan


hi,
jhcope wrote:
I have been given my first database project that requires data
encryption. [We'll be storing SSN's, CCN's, etc.] I have SQL Server
2000 and MSDE 2005 as my choice of databases. The project is small
enough that MSDE would work. My question is does MSDE 2005 have the
encryption capabilities of SQL Server 2005 and are those capabilities
sufficient to meet Federal regulations for data security?

SQLExpress supports the full set of encryption as the full SQL Server
2005 editions..

Since the project is a small one, is MSDE 2005 a better choice than
SQL Server 2000 with a third party encryption tool, since the SQL
Server 2000 that I'd use is hosted by my Hosting company on a shared
SQL Server?

....
unfortunately I'm not able to solve this dilemma...
your policies and/or standards should be evaluated... SQLExpress can
be an
optimal solution, but lacks some features that could be required, such
as
SQL Server Agent, Database Mail, DTS/SISS features and the like... or
the
new Service Broker related features as well... you have to balance all
your
requirements and the supported features....


.

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Views
    ... you must understand that SQL Server 2000 does not support ... database data encryption as such. ... following method in the KB below to enhance the security. ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.programming)
  • Re: Protecting database from administrators
    ... >> there is no encryption while at rest it must still be secure. ... >> All the security MS has offered is weak. ... If it is attached to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE Security (aka users looking at my apps database)
    ... > I have been called in more than once to untangle all sorts of developer ... let's think about a genious tool, RAC by SQL Server MVP Thanh Ngo.. ... even if SQL Server encryption has been defeated... ... think to privacy protection for sensible data... ...
    (microsoft.public.sqlserver.msde)
  • Re: encryption / decryption
    ... There are no supported encryption functions in SQL Server 2000. ... may provide other features to help you out. ...
    (microsoft.public.sqlserver.programming)