database error when using Common Integration Membership Provider



I've implemented the EPiServerCommonIntegrationMembershipProvider as described here:

And i've also added the module as described here:

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.

Apr 11, 2011 16:09


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.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.