title: the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net app
body: <p>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'."</p>
  
  <p>I know this is due to permission. SQL server is based on windows authentication. </p>
  
  <ul>
  <li>What is the best approach to manage user to connect SQL Server?</li>
  <li>Should I enable SQL Server authentication?</li>
  </ul>
  
  <p>Let me know what to do so that it makes the production feel and there wouldn't be any problem during deployment.</p>
  
  <p>Note: SQL Server is installed on domain server.</p>