How to Add Users Using SQL Server Management Studio


Microsoft introduced SQL Server Management Studio with the release of SQL Server 2005 in order to integrate the SQL management environment. Prior to SQL Server 2005, features of SQL were found in three separate applications: Enterprise Manager, Query Analyzer and Analysis Manager. With the release of SQL Server 2005 all of these features are combined within SQL Server Management Studio for ease of use. Tools for user management also reside within the Management Studio to ease the managing individual database users.

  • Open SQL Server Management Studio.

  • Connect to the desired SQL Server.

  • Expand the server entry.

  • Expand the “Security” folder.

  • Expand the “Logins” folder.

  • Right-click on the “Logins” folder and, in the pop-up menu, click on “New Login…”

  • Click the radio button next to “SQL Server authentication.”

  • Enter a password in the “Password” field.

  • Enter the password again in the “Confirm password” field.

  • Use “Default database” combo box to choose the database the new user will have access to.

  • Click on “User Mapping” in the left window pane.

  • If this user needs access to multiple databases, click in the checkbox next to the proper database(s) in the “Users mapped to this login” window.

  • Under “Database role membership for: <database name>” select the type of role this user will have with the selected database.

  • Click “OK” to save the user credentials.

Tips & Warnings

  • It is not recommended that users be given “db_owner” roles.
  • Be certain that the roles, to which you are assigning a user, are appropriate for that user. It is not good practice, nor safe practice, to give users rights which are above what they actually need to do their job.

Related Searches


Promoted By Zergnet



Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!