Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
database error when using Common Integration Membership Provider
Update:
The error disappears when i remove the module (EPiServerCommonWindowsAuthenticationIntegration) from web.config.
Apr 11, 2011 16:16
I solved it.
It turned out i was missing a parameter in my connectionstring: "MultipleActiveResultSets=True"
Apr 11, 2011 16:38
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
H!
I've implemented the EPiServerCommonIntegrationMembershipProvider as described here:
http://blog.tomstenius.com/2009/04/episerver-community-role-and-membership.html
And i've also added the module as described here:
http://blog.tomstenius.com/2009/09/windows-authentication-in-episerver.html
This works fine on my development computer, but on our production server i keep getting this error, which drive me nuts:
[InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.]
System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) +2453561
System.Data.SqlClient.SqlInternalTransaction.Rollback() +102
System.Data.SqlClient.SqlTransaction.Rollback() +292
EPiServer.Common.Data.DatabaseHandler.Rollback() +59
EPiServer.Common.Security.Data.SecurityFactory.AddGroup(Group group) +2211
EPiServer.Common.Security.SecurityHandler.AddGroup(IGroup group) +169
EPiServer.Common.Web.Authorization.Integrator.SynchronizeUser(MembershipUser membershipUser, String password, Boolean enableCreateNew) +1984
EPiServer.Common.Web.Authorization.IntegrationHttpModule.context_AuthenticateRequest(Object sender, EventArgs e) +238
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171
It's clear to me the synchronization is started but then something goes wrong.. i cannot find the error.