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

SUMMARY

This document details the step-by-step instructions on how to assign a SQL login to a database.

  • Use the SQL Login Manager to create a new MS SQL user 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
  • 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" textbox
    • Type the login you want to assign to the database in the "Login name" textbox
    • In the Database role membership, select the role you want to grant this user.
  • Click OK
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I have more logins for my MS SQL database?

DETAILS Yes.  In addition to the default login assigned for each SQL database addon, you...

Remote Connections for SQL Server 2008

Remote Connections to the MS SQL Server are enabled for all SQL Server 2008 instances....

How can backup/export my database

You can export your database by going to http://sqladmin.oissite.net/. You need to login using...

Do you support MS SQL 2005 Express database on your servers?

DetailsNo. SQL Express is designed for desktop database development purposes and is not suitable...

Transferring SQL 2005 databases

SUMMARYThis document provides a step-by-step guide on how to transfer your current SQL Server...