the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net
- 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.