Post reply

SQl 2005 Certificates

  • August 23, 2005 at 9:36 am

    #165354

    I have not used certificates before but they are being touted on Sql 2005 as a useful feature. Can they be used to encrypt all data transmission between an intranet (internal) client and the sql server? Or is a certificate only related to authentation?

     

    TIA,

     

    Bill

     

     

  • August 26, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • August 28, 2005 at 9:43 pm

    #585739

    Certificates (along with symmetric and asymmetric keys) in SQL Server 2005 have different uses. For one, it can be used to check the identity of an user. Second, it can be used to encrypt data in the server (for example: credit card numbers). Third, it can be used in Service Broker communication for encrypting at the Dialog level or the Transport level and also for authentication. Fourth, it can be used to sign modules (like stored procedures) to protect and verify the authenticity of the code.

    Here is a good starter article: http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/default.aspx

    HTH,

    Srinivas Sampath

    HTH,
    Srinivas Sampath
    Blog: http://blogs.sqlxml.org/srinivassampath

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply