Wednesday, 30 March 2011

Explain the Authentication modes of SQL Server

Windows Authentication and Mixed Mode Authentication

1.Windows authentication mode allows users to connect using Windows domain like NT/2000 account. The access to the SQL server is controlled by Windows NT/2000 account or group used when logged in. this means that Windows username and password are used to access the database server.

2.Mixed mode authentication: - Mixed mode allows use of Windows credentials and the local SQL server account.

No comments:

Post a Comment