windows authentication vs sql server authentication for asp.net forms authentication site
- by Brij
I have a database and a site having forms authentication. It is working fine with VS2008. This time, I am using "Trusted_connection =True". But when it is opened from outside or directly from browser then I am getting error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
I know this is due to permission. SQL server is based on windows authentication.
What is the best approach to manage user to connect sql server?
Should I enable sql server authentication?
Let me know what to do so that it makes the production feel and there wouldn't be any problem during deployment.
Note: Sql server is installed on domain server.