Help, I'm disperate

[DanielaTm]

Hi,
I am disperate: I have to set a password on a single sql server express (2005) database.
Can anyone know how to do it?
Thanks

[Shuja Ali]

I guess you canot set a password for a Database, although you can encrypt it.

Take a look at these
http://blogs.msdn.com/lcris/archive/2005/12/20/506187.aspx
http://msdn2.microsoft.com/en-us/ms187648.aspx

[DanielaTm]

Hi,
My client want to implement something like this:
no matter what connection to sql server 2005 the user choose, to my database and my database only,to exist a user name and password, and only if the client know the password to view the database. Otherwise, not even see the structure of the database.
How could I implement such a thing??