windows authentication or sql authentication ?

Question

hi which is better or when we should use this? regard kamran

Bechir Bejaoui · Answer

The windows authentification is simpliest The sql authentification is more complex but more robust use the sql authentification in a multi users context use windows authentification in a mono user context

Kamran kamaei · Answer

what a bout for a web application? as you know a web application connect to sql with 'NT AUTHORITY\NETWORK SERVICE' user.

Vijaya Kadiyala · Answer

HI Windows Authentication is for the environment that all of your users are part of a Windows domain (have a Windows NT/2000 user account or is a member of a group). Your access to SQL Server is controlled by your Windows NT/2000 account or group which is authenticated when you log on to the Windows operating system on the client. If you have a mixed environment (e.g. Windows and Novell) then you have to use SQL Server Authentication where you will have to create a Login ID and Password in SQL Server. Check out the below link http://database.ittoolbox.com/documents/popular-q-and-a/windows-authentication-vs-sql-server-authentication-1874 Thanks -- Vj http://dotnetvj.blogspot.com