IIS 7 and Above
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Last post Jul 31, 2012 05:58 PM by gorillamann
Jun 01, 2012 12:57 PM|NickGoddard|LINK
I have just published our first MVC3 app and I'm getting the above error.
We are using IIS 7 on a Windows Web Server 2008 R2 , the application is setup using the Intranet model. I have set its own Application Pool with the ApplicationPoolIdentity.
The SQL Server it is trying to access is on a seperate Windows 2008 R2 server and is SQL Server 2008 R2.
I hope someone can help as I'm new to this and have been scratching my head for well over a week on this.
The entry in the Windows Log on the web server is:
SQL Server 2008 R2
IIS7 .net 4
Jun 02, 2012 04:52 PM|owjeff|LINK
Jun 06, 2012 06:52 AM|kctt|LINK
It looks the issue is database connection.
In web.config file you should change connection method to sql login.
It is something like this
<add name="DatabaseConnectionString1" connectionString="Data Source=sql-server;Initial Catalog=database-name;Persist Security Info=True;User ID=database-user;Password=dbpassword" providerName="System.Data.SqlClient"/>
Jun 12, 2012 10:39 AM|NickGoddard|LINK
Jul 31, 2012 05:57 PM|gorillamann|LINK
Hi, even if I put the correct settings for the connect string I still get this error when I try do stuff int he database.:(
Jul 31, 2012 05:58 PM|gorillamann|LINK
FYI, I am using the the ApplicationPoolIdentity for this site