Are you getting this error? Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Hopefully this will fix your problem, if it is similar to mine:
Today I was testing the implementation of a simple update command on a new Windows 2008 Web Server I had just setup:Using con As New SqlConnection(bd.GetConnectionString)
Dim sql As String = _
" UPDATE blah set blah to blah"
Dim cmd As New SqlCommand(sql.ToString, con)
cmd.CommandType = CommandType.Text
The actual connection string was also very simple using Integrated Security:add name="myConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=MyDBA;Integrated Security=True"
But running this update generated the infamous:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I had fixed this previously in 2008 when I had the same issue with my Membership Provider, so I suspected the same steps would resolve this problem.
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.
Under sites, go to your website. In the Features View panel, select "Authentication" under IIS. Under ASP.Net Impersonation, make sure it's Disabled.