Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Question

I want to connect my application page with the sql server so that I can read the data from the SQL server. TO create the connection string I have used:

string cnn = ConfigurationManager.ConnectionStrings["SharePointFBA"].ConnectionString;

using (SqlConnection conn2 = new SqlConnection(cnn))
{
  cnn.open();
}

But when I execute the code, I get following error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

Answer 1

In IIS7 on your Windows 2008 Web Server...

Please go to Application Pools.

Select your web site.

Click "Advanced Settings" in the "Actions" panel.

Under "Process Model" select "Identity."

In the popup, select the "Custom account" radio button.

"Set" the account and password to your dbo account name and password that are used on your SQL Server 2008 database.

Save that.

Under sites, go to your website. In the Features View panel, select "Authentication" under IIS. Under ASP.Net Impersonation, make sure it's Disabled