hi
which is better or
when we should use this?
regard, kamran
Loading
hi
which is better or
when we should use this?
regard, kamran
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bechir BejaouiPosted Jun 29, 2008, 7:25 AM
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 kamaeiPosted Jul 1, 2008, 3:41 AM
what a bout for a web application?
as you know a web application connect to sql with 'NT AUTHORITY\NETWORK SERVICE' user.
Vijaya KadiyalaPosted Jun 30, 2008, 2:43 PM
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