How do I assign additional SQL logins to my SQL 2008 database?

How to assign an SQL login to a database:

1. Use the SQL Login Manager to create a new MS SQL login in the MS SQL 2008 Manager section of the hosting control panel
2. Connect to the database using SQL Server Management Studio with your primary login (see this Knowledge Base article)
3. In Object Explorer, epand the Databases node 
4. Locate the database to which you want to add the new SQL Login and expand the node
5. Expand the Security Node
6. Right click on the Users node and select "New User..."
7. 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 database fixed role you want to grant this login (db_owner fixed database role includes full set of permissions). 
8. 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:

1. Open Management Studio
2. Click on the database node
3. On the right hand window, you should see a list of databases.
4. Right Click on the tab. This should bring up all the available options.
5. Make sure you uncheck everything except Name.

If your database still does not show up after following the above steps, please open a ticket with our Support Department.

Article ID: 189, Created On: 11/13/2008, Modified: 1/10/2012