SQL SERVER MANAGEMENT STUDIO

Navigation To Create New Database Login and Password

Step1: Open SQL server Management Studio using admin login (sa) and password (sa123).

 

Step2: In Object Explorer right click on SecurityàNewàLogin

Step 3: Here you will got a New Login window

1. Enter your required name in the login name
2. Select SQL Server Authentication and enter your required password and confirm that password
3. Un-Mark User must change password at next login
4. Select your required database from the database list box (Sample)
5. Finally Click OK

Step 4: In Object ExploreràExpand DatabasesàExpand your database(Sample)àright click on SecurityàNewàUser

Step 5:Here you will got a New User  windo

1. Enter the Same name in User Name and Login name Text Boxes as you entered in Step 3.
2.  Click OK

Step 6: Open SQL Server Management Studio using above created Login and Password