August 17, 2008 at 6:28 am
I want to lock a password for my database when i disterbuting to my clients so if any client makes click to database name ther requires a password? can any one help me?
August 17, 2008 at 6:55 am
If I understand you correctly, you're looking for some way to prevent anyone from reading your database from a tool like management studio?
If so, it can't be done. If a person is administrator on SQL Server, they have full access to all DBs without restriction. Also, passwords are specified at the server level, not at the database level
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2008 at 10:56 am
Gail is correct. A database is part of the server, which is used to access it. If someone can access the server administratively, they can access the data.
If this is a one time thing, meaning to ensure your client correctly can get the database when you send it to them somehow, you can zip it and password protect it (not much protection), or use a utility like litesped or Red Gate SQLBackup to encrypt a backup. The client would need the password and those products have a utility to extract the backup back to the normal format for free.
August 18, 2008 at 2:06 am
Dear,I mean in the Enterprise Manager I can open it without asking any password not like Query Anlayzer,So How I can lock a password for my Database suppose it named XXX and when I installed the Sql server the user was sa and password was 345 so when I open SQL Server>Enterprise Manager I want to get a dialog or something like that requiring me a password like Query Anlayzer
Thanks
August 18, 2008 at 2:16 am
Query analyser's asking for the login's password. All that's happening with enterprise manager is that it remembers the passwords when you add the servers to the tree. A person needs to know the password (or have appropriate access via their domain login and use windows authentication) before they can add the server.
If the person in question is an admin, they don't need a password in Query Analyser either. Just set the login to Windows Authentication rather than SQL authentication.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2008 at 2:51 pm
what gail said is absolutely correct
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply