Standard security uses SQL Server's own login validation process for all connections. To log into a SQL Server, each user must provide a valid login ID and password.
When a server's login security mode is set to standard and a user attempts to log in to the server, SQL Server looks in the syslogins table for the user's login ID and password. If the login ID and password given are valid, the user is connected to the SQL Server.
For instructions on setting up standard security (beginning with an overview of each task required to do so), see Chapter 9, Managing Security.