SQL Server Login Properties - New Login

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

SQL Server Login Properties - New Login

Use this dialog box to view or specify the following options.

Options

Name

Specify the name for the new login.

Windows Authentication

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.

Domain
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.

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

Database

Specify the default database for the selected login.

Language

Specify the default language for the selected login.

See Also

Adding a SQL Server Login