Create SQL Login via SQL Server Management Studio in SQL Server 2008

In this article I will explain how to create login using SQL Server Management Studio.
  • 3175

Introduction

SQL Server login is nothing but simply a credentials to access SQL Server. For example you provide username and password to access e-mail account. Using credentials decides what the user is allowed to access in SQL Server. For example , a specific user is not allowed to access a particular database or even to alter it.

There are various methods to create SQL Server login.

  1. Using SQL Server Management Studio.
  2. Using SQL query.
  3. Using system stored procedure

In this article I will explain how to create login using SQL Server Management Studio. Go through following steps to create login.

Step 1

Open SQL Server Management Studio and connect to database engine.

Step 2

In object explorer step down to the Security object node. Right-click a Logins node and choose New Login from popup menu.

LoginNode sql.jpg

Step 3

When you click on New Login you will get the below window.

LoginWindow1.jpg

Step 4

Enter the login name.

enter new login name.jpg

Step 5

Choose the authentication either windows authentication or SQL Server authentication and choose the default database to which user is allowed to access. Choose Default language for the user.

choose authentication sql.jpg

Step 6

In the Login-new window, from left panel choose Server Roles. You can specify the role of the user and it's server role. Here I choose public and sysadmin.

server roles sql.jpg

Step 7

In the Login-new window, from left panel choose User mappings to decide level of access of user to access databases.

user mappings sql.jpg

Step 8

In the Login-new window, from left panel choose Securables so that you can choose the object on which you want to provide or deny access. For example I select mcndesktop34 and select deny create database.

securables sql.jpg

Step 9

In the Login-new window, from left panel choose Status which specifies the current status of user. Click OK to save all settings.

status sql.jpg

Step 10

Refresh the Login node from object explorer. You will see new login named MCN is created.

login created.jpg

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.