Creating and Configuring a User in MSSQL


This article will show you how to create and configure a user in MSSQL

1. Open SQL Server Management Studio (SSMS)

2. Connect to SQL Server using the proper credentials (for more on this see Configuring SSMS to connect to SQL Server)

ssmsconnect.PNG

 

3. Expand Security and Logins

ssmslogins.PNG

 

4. Right click Logins and select New Login

ssmsnewlogin.PNG

 

5. On this page you assign a Login name and select the authentication method and default database/language. (Note only Domains can use Windows Authentication) If you are using SQL authentication you will need to enter an initial password and choose the enforcement options for password policy and expiration as well as whether or not the user will need to change their password when they log in.

ssmsnewlogin1.PNG

 

6. Click on Server Roles and you can assign any sever roles you want this user to have.

ssmsnewlogin2.PNG

 

7. Click on Securables and then click the Search button. This will bring up the Add Objects dialog box where you can choose specific objects, objects of a certain type or the server itself. Select one and click Ok

ssmsaddobjects.PNG

 

8. Select Grant, With Grant or Deny as necessary for any/all of the objects in the explicit box. (Grant will grant access to the securable, with grant will allow the user to grant access to the securable and deny will expressly deny permission to the securable no matter what roles or permissions the user may have)

ssmsnewlogin3.PNG


9. Click on status to grant or deny permission to the Database Engine, enable or disable the login and to unlock the account should it get locked out. When all this is done click on OK to create the user.

ssmsnewlogin4.PNG



Was this content helpful?




© 2011-2013 Rackspace US, Inc.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License


See license specifics and DISCLAIMER