How to create User Login in Sql Server 2005/2008
How to create User Login in Sql Server 2005/2008 Note - You must be a member of "system admin" to create a new user or database. Following is the steps to create user login in database for database level security :- Step 1 . Open Sql Server >> Enter User Name >> Enter Password >> Click Connect Step 2 . Open Security >> Logins >> Right Click >> New Login Step 3. Enter login name >> Select Radio button "Sql Server Authentication" >>Enter password>>Enter confirm password>> Un-Check Enforce password policy >> Click Ok Step 4. Right click on Databases >> Click new database Step 5. Enter Database name>> Owner "<default>" >> Click Ok Step 6 . Open Newly created database (My Case it is Test)>> Security>> Users>> Right click on dbo >> New users. Step 7. Enter user name>> Login name >> default schema...