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 2008 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
Special note for users of SQL Management Studio 2008
If you cannot see the database(s) in Object Explorer, try the following steps:
- Open Management Studio
- Click on the database node
- On the right hand window, you should see a list of databases.
- Right Click on the tab. This should bring up all the available options.
- Make sure you uncheck everything except Name.