Create SQL SERVER Login

Steps to create Login

First Requirement
1.Login with window authentication.
2.Open object explorer.
3.Go to server and do right click -> Property.
4.In property Window -> go to security tab-> select “SQL Server and Window authentication mode”
5.Press ok

Second Requirement
1.Go the server in object explorer
2.Then go to “security tab” -> login.
3.Right click login -> Crete new login.
4.In Login New window ->Go to General tab
5.Give “Login name “You want to create. -> Then select Sql server Authentication -> give password.
6.Then uncheck “Enforce password policy”
7.Then set default database for which u want to create login.
8.Then Go to “Server Role” tab. Check all the sever role u want to give to the logger.
9.Then Go to “User Mapping” and select the database -> set user(the new logger)-> default schema (set to dbo)
10.Then give database role membership for the database u selected.
11.Then go to “Status” tab set “Grant” permission to connect to database engine.
12.And set login enabled.
This is all you need to do to create new login.
Now you can login in server authentication mode with the new login name u just created.

Error: 18456

If you encounter login fail with the new login name u just created with error code:18456
Step to Resolve
1.Then go to Start-> Microsoft SQL Server 2008 -> Configuration Tool -> Sql Server Configuration Manager.
2.Enabled TCP/IP and Named Pipe protocol
3.Then restart Sql server service.
That all you need to do to make your login success.

Post Reference: Vikram Aristocratic Elfin Share