Server Login Properties (Authentication Tab)

Windows (Authentication)
Use Windows Authentication when connecting to an instance of SQL Server. It is recommended that you use this option for security because users who connect through a Microsoft Windows NT 4.0 or Windows 2000 user account can make use of trusted connections. Trusted connections are those validated by Windows NT 4.0 or Windows 2000.

Domain
View the Windows NT 4.0 or Windows 2000 domain. This domain account provides network access to other servers in the domain.

Grant access
Grant login access to a Windows NT 4.0 or Windows 2000 account.

Deny access
Deny login access to a Windows NT 4.0 or Windows 2000 account.

SQL Server (Authentication)
Use SQL Server Authentication when connecting to the server. This option uses SQL Server security to validate the user.

Password
Specify the password to use when connecting to the server using SQL Server Authentication.