Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SQL Server Login Properties - New Login

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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



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.

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.

See Also

Adding a SQL Server Login

© 2015 Microsoft