SQL Server Login Properties - New Login
New Information - SQL Server 2000 SP3.
Use this dialog box to view or specify the following options.
Specify the name for the new login.
Use Windows Authentication when connecting to an instance of Microsoft® 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.
Security Note When possible, use Windows Authentication.
- Specify the domain to use to validate a login's network security attributes. SQL Server achieves login security integration with Windows NT 4.0 by using the security attributes of a network user to control login access. A user's network security attributes are established at network login time and are validated by a Windows domain controller.
- Grant access
- Grant access to the login.
- Deny access
- Deny access to the login.
SQL Server Authentication
Connect using SQL Server Authentication. When a user connects with a specified login name and password from a nontrusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and the user receives an error. For more information about SQL Server Authentication, see Authentication Modes.
- Specify the password to use when connecting to the server using SQL Server Authentication.
Specify the default database for the selected login.
Specify the default language for the selected login.