How to assign an SQL login to a database:
- Use the SQL Login Manager to create a new MS SQL login in the MS SQL 2005 Manager section of the hosting control panel
- Connect to the database using SQL Server Management Studio with your primary login (see this Knowledge Base article)
- Expand the Databases node
- Locate the database to which you want to add the new SQL Login and expand the node
- Expand the Security Node
- Right click on the Users node and select "New User..."
- In the Database User Properties
- Type the username you want to assign to this login in the "User name" text box
- Type the login you want to assign to the database in the "Login name" text box
- In the Database role membership, select the role you want to grant this login.
- Click OK