System Status
Buy Now
  • Email & Apps
  • Office 365
Login
  • MyRackspace Portal
  • Cloud Control Panel
  • Rackspace Webmail Login
  • Cloud Office Control Panel
  • Support Home
  • How-To
  • Developer Documentation
  •  Blogs 
    • Expert Insights Tech Blog
    • Rackspace Blog
    • Solve: Thought Leadership

Support Network

End-to-End Multicloud Solutions.   Solving Together.â„¢   Learn more at Rackspace.com

How–To Home

Cloud Servers

  • Introduction
  • FAQ
  • All Articles

Create and configure a user in MSSQL

Last updated on:  2020-07-27

Authored by:  Rackspace Support


Use the following steps to create and configure a user in MSSQL®:

  1. Open the Microsoft ® SQL Server® Management Studio (SSMS).

  2. Connect to SQL Server by using your login information.

  3. In the left-hand panel, expand Security > Logins.

  4. Right-click Logins and select New Login from the drop-down menu.

  5. Assign a login name and select the authentication method and default database or language.

    If you are using SQL authentication, you must enter an initial password and choose the enforcement options for password policy and expiration as well as whether or not the user needs to change their password when they log in.

  6. In the left-hand panel, click Server Roles to assign any server roles you want this user to have, including bulkadmin, dbcreator, public, and so on.

  7. In the left-hand panel, click Securables and then click Search.

    The Add Objects dialog box displays, where you can choose specific objects, objects of a certain type, or the server itself. Select one and click OK.

  8. On the Securables page, select Grant, With Grant, or Deny as necessary for any of the objects in the explicit box.

    Grant gives access to the securable, With Grant allows the user to grant access to the securable, and Deny expressly denies permission to the securable no matter what roles or permissions the user might have.

  9. In the left-hand panel, click 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 you have finished modifying the settings, click OK to create the user and exit the new login creation window.

Share this information:

©2020 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

About Rackspace
  • About
  • Customer Stories
  • Events
  • Programs
Blogs
  • The Rackspace Blog
  • Expert Insights Tech Blog
  • Solve: Thought Leadership
  • News
  • Contact Information
  • Legal
  • Careers
Site Information
  • Style Guide for Technical Content
  • Trademarks
  • Privacy Statement
  • Website Terms
Support Network
  • Support Network Home
  • Rackspace How-To
  • API Documentation
  • Developer Center
  • ©2020 Rackspace US, Inc.