SQL Server Login Properties (General Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

SQL Server Login Properties (General Tab)

Use this tab to view or specify the following options.

Options

Name

Specify the name of the Microsoft® SQL Server™ login.

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.

Database

View the default database for this login.

Language

View the default language for this login.

See Also

Logins

Managing Security