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.