Quackit Logo

Got a MySpace Page?

Get "www.yourname.com" for your MySpace page. Learn how >>.

SQL Server - Create a Login

Print Version

In the previous lesson about SQL Server security, we learned that SQL Server allows for the creation of different logins for different users. These logins can be assigned to any number of roles, depending on the access that user is entitled to.

In this lesson, we will walk through the steps in creating a login.

To Create a New Login

  1. Using Enterprise Manager, expand the "Security" option and right click on "Logins"
  2. Click on "New Login"
    Creating a new login in SQL Server

    Tip: You can bypass the above steps by clicking on the "New Login" icon New login icon in the top menu

  3. Complete the Login Properties in the "General" tab by providing a name for the login, choosing the Authentication method (providing a password if you choose "SQL Server Authentication"), and selecting the database to use as a default. If you don't choose language, it will use the default for the current installation of SQL Server.
    SQL Server Login Properties - General tab
  4. Click the "Server Roles" tab if you need to apply any server-wide security privileges.
    SQL Server Login Properties - Server Roles tab
  5. Click the "Database Access" tab to specify which databases this login is allowed to access. By default, the login will be assigned to the "Public" role, which provides the login with basic access. If the login needs more access in one or more databases, it can be assigned to another role with greater privileges.

    Note that these roles are "Database Roles" and are different to the Server Roles in the previous tab. Server Roles are for administering the SQL Server. Database Roles are created within each database and specify what the login can do within that database.

    SQL Server Login Properties - Database Access tab

Enjoy this website?

  1. Link to this page (copy/paste into your own website or blog):
  2. Add this page to your favorite social bookmarks sites:
                     
  3. Add this page to your Favorites

Oh, and thank you for supporting Quackit!

FREE Hosting!

With every domain name you register with ZappyHost, you get FREE (ad supported) hosting.

PLUS you get:

  • FREE Website Builder
  • FREE Blog
  • FREE Starter Web Page
  • FREE Email Account
  • & much more! (Total value $123 for FREE!)
Get your FREE hosting today! >>