There are two important aspects to SQL Server security, authentication and permissions.

Authentication only checks whether the user has a login account and is allowed to connect with SQL Server.

Permissions checks which databases the user is allowed to access, and what they are allowed to do in these databases.

There are two possible authentication modes for SQL Server:

• Windows NT Authentication Mode (Windows NT Authentication)
• Mixed Mode (Windows NT Authentication and SQL Server Authentication)