Authentication modes in SQL Server

Hi,

There are two types of modes in sql server.

1. Windows Authentication

2. Sql Server authentication

Windows Authentication:

The Windows authentication is trusted connection in sql server. The windows authentication mode checks the current logged in user credentials against the windows user account.

SQL Server achieves login security integration with Windows NT 4.0 or Windows 2000 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. When a network user tries to connect, SQL Server uses Windows-based facilities to determine the validated network user name. SQL Server then verifies that the person is who they say they are, and then permits or denies login access based on that network user name alone, without requiring a separate login name and password.

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

You can get the more details on MSDN:

http://msdn.microsoft.com/en-us/library/aa905171(v=sql.80).aspx

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi,

There are two types of modes in sql server.

1. Windows Authentication
2. Sql Server authentication

Windows Authentication:
The Windows authentication is trusted connection in sql server. The windows authentication mode checks the current logged in user credentials against the windows user account.

SQL Server achieves login security integration with Windows NT 4.0 or Windows 2000 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. When a network user tries to connect, SQL Server uses Windows-based facilities to determine the validated network user name. SQL Server then verifies that the person is who they say they are, and then permits or denies login access based on that network user name alone, without requiring a separate login name and password.

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

You can get the more details on MSDN:

http://msdn.microsoft.com/en-us/library/aa905171(v=sql.80).aspx
0