Anoop Bansal

Anoop Bansal

  • NA
  • 58
  • 5.8k

Protect Sql database

Mar 2 2017 1:05 PM
Hi
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 

Answers (1)