How to set password or authentication for .mdf(service based database) file in vs2010?

Question

I am developing a stand alone windows application in c# I am using service based database.

Can anyone tell me how to protect .mdf database from copying or attaching to sql server management studio without password from Client's machine ??

Is there any way to set Sql authentication for .mdf file ?

Hi, did you find any solution for this? – S. B. Aug 11 '22 at 13:56 — S. B., Aug 11 '22 at 13:56

score 1 · Answer 1 · answered Sep 10 '16 at 03:23

1

In the data folder any one can take database(.mdf file). And in import into their own sqlserver. We want to protect data. If some body take our database (.mdf file) then it can not import it into their own system.

answered Sep 10 '16 at 03:23

Ameer Chand

51
4

score 0 · Answer 2 · answered May 02 '15 at 16:42

0

No, is not possible.

If you want to prevent your users from using the database directly then you must host the database yourself, which implies making your application a Web service rather that a standalone Windows app.

Do not fall for various scams that pretend they offer a solution for this problem. Is all snake oil.

answered May 02 '15 at 16:42

Remus Rusanu

288,378
40
442
569

Then how the companies are deliver their software with database? – Muhammed Suhail May 02 '15 at 17:00
My aim is to deliver a software with oneclick installation(software+sql server) – Muhammed Suhail May 02 '15 at 17:01

Mamad · Answer 3 · 2016-06-06T10:32:47.340

0

just use SQL Server instead of SQL Express add your SQL database file to a installed SQL server Machine And Change Connection string to connect to it via SQL server then you can set password on your database in SQL server

edited Jun 06 '16 at 10:32

answered Jun 06 '16 at 10:24

Mamad

446
5
22

How to set password or authentication for .mdf(service based database) file in vs2010?

3 Answers3