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..........

No comments:

Post a Comment