How to provide password to SQL Database

[Yogesh Ful]

If we log in through Windows authentication then it is not required password and if we login through SQL server authentication then it is required password.

My Question is hot to give password to SQL database so that another person cannot access our database.

[ck9663]

This happens when you setup Mixed Authentication. For user databases, you still have to setup individual user rights, unless the user is a member of a specific group.

Most of the time, user can login, but they don't necessarily always have access to db.


Good Luck!!!


~~ CK