How to make secure local SQL database for C# application

Question

I have a C# application with .NET 3.5 and SQL SERVER 2008 R2. I want to make a setup project and i want to install each user db while installation.

I use local db when i import database as application file, the database is available and anyone who has access to the laptop os has access to the database. because the local db' s are not for the multiuser scenarios.

how to secure the database file' s from access or being modified? it contains sensitive data for application behave.

are you worried about the whole db or the contents that you put into db? depending on this multiple scenarios are possible. — zaitsman
– zaitsman, Commented Feb 25, 2015 at 9:09
the important matter is contents of DB. when it comes to comparison whole db is Second — user3786134
– user3786134, Commented Feb 25, 2015 at 9:11
Cool. So what you can do is for example use t-sql crypto functions (msdn.microsoft.com/en-us/library/ms173744.aspx) or encrypt in code using symmetric (e.g. Aes) or asymmetric (e.g. PKCS7 envelope) methods. — zaitsman
– zaitsman, Commented Feb 25, 2015 at 9:12
how can i encrypt the whole data with a key ? Is it even possible? and access it by that key — user3786134
– user3786134, Commented Feb 25, 2015 at 9:21

Ashwin Marthak · Accepted Answer · 2015-02-25 09:07:11Z

1

Create in sql windows authentication to server authentication then you can add username and password then you can secure your database

answered Feb 25, 2015 at 9:07

Ashwin Marthak

263 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ashwin Marthak Over a year ago

if you want to create database at the time of installation then you need installer class then give you reference in setup file

user3786134 Over a year ago

the data base file will be packed and ready to use for each different clients. should i use SQL impact?

Collectives™ on Stack Overflow

How to make secure local SQL database for C# application

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related