Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and stored on the server. SQL Server provides support for encrypted connections, encrypting data, encrypting database and for encrypted storage.
Basit's SQL Server Tips 
Assalam Alaikum mr. basit
I need your help for:
How can prevent users to reach my sql server 2008 database?
Can I secure it by password like Access DataBase ?
I notice that if any one take a copy of (my sql server 2008 database), then attach it in other computer he can see whole data and he can use my database in his purpose…
Can you kindly solve my problem even by cost..
thanks
LikeLike
Walakumusalam Marwan, The best and most sure way to accomplish this is to use transparent data encryption (TDE). When the database is encrypted using TDE, no one can restore it, attach it, or, copy it, unless he has the certificate for the database. See my article for more info here: https://basitaalishan.com/2012/07/08/securing-database-contents-with-transparent-data-encryption-tde/
LikeLike