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


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 connect to your SQL server using an alternative port?

DETAILS No, the only open port is 1435.  If you find that your ISP or firewall is blocking...

If I send you a backup (.bak) of my SQL Database, can you restore it?

DETAILSYes.  We do restore database backup files from your SQL Server.  But you have to...

Remote Connections for SQL Server 2005

HELM4 Accounts: Connection information can be found within the Database Manager screen. to get to...

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...

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...