Monday, 26 March 2012

How to add a SQL Authenticated Login User in MS-Sql Server

In order to create a login user in sql server follow the following steps:-

step-1: Open MS-SQL Server  and click Security and then click Logins.
 

Step-2: Now right click on the Logins and click "New Login..."
 

Step-3: You will see a window below as :
 
Step-4: Now give the name for the login user & choose SQL Server Authentication and this will make the password fields enable, give the password and confirm password uncheck the Enforce password policy and click OK that all..


 Enjoy it..........