August 01, 2009

Creating a Self-Signed Certificate in SQL Server 2005/2008

In simple worlds, Certificates can be used to secure data in SQL Server. There are a number of ways to create a certificate - from a file, from a signed executable file or from an assembly. You can also create a Self-Signed Certificate which is the easiest of all as shown here. They are called self-signed as they are not generated by an authority but by SQL Server itself.

To secure an object, you can first create a certificate, map it to a database user and then sign the object with that certificate.

Here’s how to create a self-signed certificate.

USE Social;
EXPIRY_DATE = '12/31/2009';

You can read more about symmetric keys, asymmetric keys and other kind of certificates over here

Did you like this post?
kick it on
subscribe via rss subscribe via e-mail
print this post follow me on twitter

About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal



0 Responses to "Creating a Self-Signed Certificate in SQL Server 2005/2008"

Copyright © 2009-2016 All Rights Reserved for by Suprotim Agarwal | Terms and Conditions