As you have specified in your post, setting individual database password is possible in sql server2005.
Will it be able to protect your db even if someone copies the mdf file and then tries to attach it to his system using Windows authorisation or sa login.
If yes, Kindly share the procedure.
My requirement in detail is as below
Please help me with this
I need to lock a sql database with my own password, such that it can't be opened through windows authentication mode also.
I have a small applicattion that uses sql server2005 database.
So far I used to supply the application with online database and all sort of security so that no competitor of mine can steal it.
Now for one of my clients, I need to install the application to work in offline mode. i.e. I need to put the database also on his local machine.
Now If someone wants to copy the db and use it develop his own application similar to mine, He can follow following steps
1) If I only install sql express edition and provide mdf ldf files,
He can copy it and attach to his another machine with Windows authentication mode and see my stored procedures and table schemas
2) If I install sql server and create a new user say LPS with a pwd and delete all the other users including windows authentication .
He cannot copy the db as its attached to sql server and cant open sql server to detach this and then copy,
But if he uninstalls sql from his machine and re installs it, he will have sa password reset to whatever he wants and then use it.