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