You don't passwords for a database in SQL Server. You create users (either windows active directory users or typically sql users), and assign them access to various objects such as databases, tables, stored procedures, etc... Multiple users can have various levels of access to the same database.