, , ,

How to make user in Sql server database.

To make a user in sql server you have the rights. to create user go to Security=>>

Logins>> Right click on Logins

Login Name : jayant

Select option:Sql server authentication

Un check : Enforece password policy. Refer Image Below

Now close sql management studio and re login with jayant

Try to access other databases, it will show error, means you have sucessfuly make a new use for new datbase.