Encrypt the MS SQL database

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,
i want to encrypt my MS-SQL database that no one can read it but my application,i wrote the application in c# language.
I simply can encrypt MS-sql database in my local computer but i want to install the application on other computers,that i don't want them read my database.
please give me a solution & excuse me for my poor english.

THANKS very much.....

Posted 10-Sep-12 22:04pm

ali sedighian

Add a Solution

2 solutions

Solution 1

Have a look at this :
http://blog.sqlauthority.com/2009/04/28/sql-server-introduction-to-sql-server-encryption-and-symmetric-key-encryption-tutorial-with-script/[^]

Posted 10-Sep-12 22:06pm

Kuthuparakkal

Comments

ali sedighian 11-Sep-12 4:45am

that was a good article about encrypting but don't solve my problem,because i want it don't mention that how can i use the encrypted database in c# and it just says how to encrypt database.
although,thanks for Ur help.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Accepted Answer · 2012-09-10T22:19:00

Solution 2

Hi,

Why you are encrypting all the data? It will slow down the system. Instead i suggest you to use some complex credentials for MsSQL and Encrypt only ConnectionString.

Hope this works for you,
Thanks
-Amit Gajjar

Posted 10-Sep-12 22:19pm

AmitGajjar

Comments

ali sedighian 11-Sep-12 4:37am

thanks,
I want install database on local computer and i can't risk to lose data.is this helpful for my problem?

AmitGajjar 11-Sep-12 4:38am

it's all depend on criticality of your code. if user do not have credential , how they will open and see your data ?

ali sedighian 11-Sep-12 4:47am

that's the problem i want just application can open it and see the data.is there any solution?

AmitGajjar 11-Sep-12 4:49am

you can encrypt connection string and use that from your code. human eye can not read that encypted usernamd and password of your database. so they even can't read your database information except from your application.

ali sedighian 11-Sep-12 4:58am

thanks
And the last question how can i encrypt connection string?!?

AmitGajjar 11-Sep-12 5:01am

check http://www.codeproject.com/Tips/304638/Encrypt-or-Decrypt-Connection-Strings-in-web-confi article.

ali sedighian 11-Sep-12 5:06am

THANKS for your help verryy much.

AmitGajjar 11-Sep-12 5:07am

Your welcome. Mark solution as answered if it helps you.

Prasad_Kulkarni 13-Sep-12 5:56am

5'ed :D

AmitGajjar 13-Sep-12 6:20am

Thank you :)