Friday, March 28, 2014

Sql server authenticate Mode

In Sql server authenticate Mode:
1)Windows
2)Form
3)Sql server
4)Bassic

Sql server support Mode:
1)Windows
2)Mixed(Windows and Sql Server)

SQL Server supports two authentication modes, Windows authentication mode and mixed mode.
  • Windows authentication is the default, and is often referred to as integrated security because this SQL Server security model is tightly integrated with Windows. Specific Windows user and group accounts are trusted to log in to SQL Server. Windows users who have already been authenticated do not have to present additional credentials.
  • Mixed mode supports authentication both by Windows and by SQL Server. User name and password pairs are maintained within SQL Server.

We recommend using Windows authentication wherever possible. Windows authentication uses a series of encrypted messages to authenticate users in SQL Server. When SQL Server logins are used, SQL Server login names and passwords are passed across the network, which makes them less secure.

No comments:

Post a Comment