I am unable to set password to SQL server database. Please advise how to do it.
migrated from stackoverflow.com Nov 13 '10 at 17:13
This question came from our site for professional and enthusiast programmers.
In SQL server, there is nothing like "password for database". What you need to do is that create a "login", set it's password and then assign this login the appropriate permissions. While getting the data request is authenticated only at server level. Once a user is logged in the server, he can access all databases, and can perform all tasks for that he is authorized without any credential check any more.