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:
System
<div>
-
Provider
<div>
[ Name]
ASP.NET 4.0.30319.0
</div>
-
EventID
1309
<div>
[ Qualifiers]
32768
</div>
Level
3
Task
3
Keywords
0x80000000000000
-
TimeCreated
<div>
[ SystemTime]
2012-06-01T11:39:08.000000000Z
</div>
EventRecordID
609
Channel
Application
Computer
CLU-SCU-WEB01.galaxy.local
Security
</div>
-
EventData
<div>
3005
An unhandled exception has occurred.
01/06/2012 12:39:08
01/06/2012 11:39:08
5c78f48db4304c78a5f73d2e78421acc
9
2
0
/LM/W3SVC/3/ROOT-4-129830241249283763
Medium
/
D:\Sites\intranet\
CLU-SCU-WEB01
3620
w3wp.exe
IIS APPPOOL\Intranet
ProviderIncompatibleException
An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that
the connection string is correct. at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) at System.Data.Entity.DbModelBuilder.Build(DbConnection
providerConnection) at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext) at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
at System.Linq.Queryable.OrderBy[TSource,TKey](IQueryable`1 source, Expression`1 keySelector) at ClugstonPortal.Controllers.TabController.TabsInOrder() in C:\Users\goddarn.MILKYWAY\Documents\Visual Studio 2010\Projects\ClugstonPortal\ClugstonPortal\Controllers\TabController.cs:line
29 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext,
ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext
preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext
controllerContext, String actionName) at System.Web.Mvc.Controller.ExecuteCore() at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass4.<Wrap>b__3() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1
func) at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) The provider
did not return a ProviderManifestToken string. at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices
providerServices, DbConnection connection) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions,
Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection,
Action`1 act) at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act) at System.Data.SqlClient.SqlProviderServices.GetDbProviderManifestToken(DbConnection connection) at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection
connection)
http://intranet/
/
10.1.1.166
MILKYWAY\goddarn
True
Negotiate
IIS APPPOOL\Intranet
20
IIS APPPOOL\Intranet
False
at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) at System.Data.Entity.DbModelBuilder.Build(DbConnection
providerConnection) at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext) at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
at System.Linq.Queryable.OrderBy[TSource,TKey](IQueryable`1 source, Expression`1 keySelector) at ClugstonPortal.Controllers.TabController.TabsInOrder() in C:\Users\goddarn.MILKYWAY\Documents\Visual Studio 2010\Projects\ClugstonPortal\ClugstonPortal\Controllers\TabController.cs:line
29 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext,
ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext
preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext
controllerContext, String actionName) at System.Web.Mvc.Controller.ExecuteCore() at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass4.<Wrap>b__3() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1
func) at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
When an Internet user accesses the site, it does so as the 'NT AUTHORITY\ANONYMOUS LOGON' user. In order to allow this, you need to enable Anonymous Authentication for the site. If this is an Intranet model and you're assuming that the user should pass through
thier windows credentials, then Windows Authentication should be enabled. If that's already done but you're seeing this error, it sounds like the client doesn't have appropriate access.
NickGoddard
2 Posts
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jun 01, 2012 11:57 AM|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 MVC3
owjeff
680 Posts
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jun 02, 2012 03:52 PM|LINK
OrcsWeb: Managed Windows Hosting Solutions
"Remarkable Service. Remarkable Support."
kctt
654 Posts
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jun 06, 2012 05:52 AM|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
<connectionStrings>
<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"/>
</connectionStrings>
NickGoddard
2 Posts
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jun 12, 2012 09:39 AM|LINK
GorillaMann
18 Posts
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jul 31, 2012 04:57 PM|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.:(
GorillaMann
18 Posts
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Jul 31, 2012 04:58 PM|LINK
FYI, I am using the the ApplicationPoolIdentity for this site