How can I create password protected .mdf file.

Question

I have an application where I deploy .mdf file.
its an standalone application in windows form using .net 3.5
I dont want any other user see my DB structure without whoever created.

please give me suggestion.

Sudhakar Chaudhary · Answer

Hi Suhas.. Step: Firstly Login To the Server then >>>Security>>New Login (here You create a login for the Server ) Leave the Server Role as it is. Here You Successfully Assign the Login for Your Server.( Only Server Not to database ) Step : In This Setup Make a Login For your Database As Same as Firstly Your Created. 1) Give the Name of The User 2) In login Name give the Login Name as Your Created For Your Server 3) In The Database Role MemberShip Select as You Want(I am Selected The DB_owner) One Suggestion: Please Make Sure that Your connection String is Secure Form The Decomplilation.Like that thanks..