How to Create User in SQL Server With Pictures

43
0

Today We Will Learn How to Create User in SQL Server, Users are very important for security purpose. If you want to any person or user don’t change any query in your database. You should create user and assign role, it is perfect for you. If you have installed SQL Server and you don’t create User, after installing you can do it as well.

Basically, it is very helpful and beneficial futures in SQL Server, you can assign any database to any person as well. Then user use only use assigned database, if you want to change security future such as read query, delete Query or any other as you wish.

You May Also Like: How to Use Trigger in SQL Server

Create User in SQL Server

I will tell how you can Create User in SQL Server and Assign Role as you want. So, that’ very simple process to create user in SQL Server and assign role. In this tutorial you will learn with help of pictures and also query. You can use any one as you like.

You May Also Like: Install SQL Server 2014 Video Tutorial

First of All I tell you with the help of design mode, than query type. After that you will create user in sql server as well. Basically, there are two ways I will tell you step by step.

How to Create User in SQL Server?

Step 1: First of All you need to open SQL server and connect with Windows Authentication mode. Below I have shared screen shot you can see here.

Conntect-SQL-Server-with-Windows-Authentication-mode

Step 2: After the connect SQL Server, you need to right click Server Name>Properties. You can see below screenshot attached.
Go-to-Properties-in-SQL-Server

Step 03: After that left side you can see Security Option Click It. After Cilcking You can See Server Authentication Options, Check Second Option SQL Server and Windows Authentication Mode.

Select-Security-Option-and-Check-to-SQL-Server--and-Windows

Step 04: After that Simple Click OK Button, After Click OK Button You need to Restart Server Name. Right Click Server Name Like (DESKTOP-QG2VIHO) than Cilck Restart Button.

Restart-Server

Step 05: After Complete Above Procedure you need to Right Click Security Folder>New>Login. Below Screenshot Attached you can see here.

Right-Click-Security-New-LoginStep 06: After that Left Side General Options, Enter Login Name as you like. Select SQL Server Authentication, than Enter the Passowrd. Check Only Enforce Policy Option, uncheck another checked options. Below Screenshot attached you can see here.

General Options in SQL Server

Step 07: After complete above procedure, you need to Click Server Roles Option. After Click Server Roles Option you simply check sysadmin Option.

Server-Role-OptionStep 08: After that you need to Click User Mapping Option. After Clicking User Mapping check Database If you want to authorize. Here I have selected Tutorial Database Checked, and don’t change any other options.
User-Mapping-OptionStep 09: After that Click Securables Option and Click Search Button. Below I have shared Screenshot of this option, you can see here.Securables-OptionStep 10: After Click Search Button, you can see Add Object Option. You simply Click Third Option “The Server (DESKTOP-QG2). Below I have shared screenshot of this option.

Add-Object

Step 11: After Click Add Object Option, you can Server Name automatically dispaly in your Securables Box. That’s it simply click Ok, Button and Disconnect to Windows Authentication mode or Restart SQL Server. Select Authentication Mode Like (SQL Server Authentication), than you need to enter user Name and Password. Connect-with-User-AccountThat’s it you can connect SQL Server with the help of User Name and Password as Well. Above All mentioned knowledge for How You can create user in SQL Server.

You May Also Like: How to Use Inner Join in SQL Server

If you want to learn How you can do it with the help of Script or Query. Below I have shared Query or Scrit you can learn.

Sql Server Create User Script

Script or Query is very helpful and beneficial versus design mode. You can use query to make a user quickly as well.

Basically, I have all ways check than I will share this knowledge on my Website. If you have any question / suggestion on this topic. Kindly Comment me or suggest me After Received your Comment or Email. I will reply with you maximum 24 Hours.

You May Also Like: Stored Procedure in SQL Server

Thanks for visit my blog/website, Kindly Share or Subscribe my Social network pages for getting updates.Thanks Again.