Protect Sql database

I am building a project using WPF and SQL Server 2012, I want to protect my database from being viewed/access by other people, as it can ONLY interact with my application which having userid and password (as used in connection string).

Problem:

As client user is also using SSMS on their particular PC, and I donot want to give access to any user, inspite it can ONLY be accessable with my application.

When deploying my application to client pc, I am installing .net framework and sql server express so that my application works with it.

Is installing SQL Server express on the client machine is ok? or is there any runtime available so that my application can work with it.

Please suggest me something for protecting my database as I am preety new to SQL.

Thanks
Anoop

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Did you manage to have a look at LocalDB?

One "highly unconventional" suggestion. If you do take LocalDB path, typically you directly open your .mdf / .ldf files and no sql server installation required. You may choose to name your .mdf and .ldf file the way you want. What I wanted to imply is what if your .mdf is named as reports.dll and .ldf named as subreports.dll?

Who on earth is going to imagine that these are actually database files?