Hi,EPiServer CMS 5 Release , MS SQL 2000
I have deployed the local database and site to the production environment. The site works appears to work fine However, when I add a user to a group I get the following message:
Unexpected Provider error! This may be caused by invalid combination of Role and Membership providers
I have checked the provider in the web.config and they are the same as the development version (SqlServerRoleProvider). I can add / edit /delete users and I can add / delete groups. I just cannot assign a user to a group?
Can anyone shed some light on this or point me in the right direction?
James, did you solve this?
I got this problem aswell after deploying to production environment. In web.config the defaultProvider is set to SqlServerRoleProvider for roleManager and for membership the defaultProvider is set to SqlServerMembershipProvider.
The error message says "Unexpected Provider error! This may be caused by invalid combination of Role and Membership providers." and:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Web.Security.SqlRoleProvider.RemoveUsersFromRolesCore(SqlConnection conn, String usernames, String roleNames) at System.Web.Security.SqlRoleProvider.RemoveUsersFromRoles(String usernames, String roleNames) at System.Web.Security.Roles.RemoveUserFromRoles(String username, String roleNames) at EPiServer.UI.Edit.UserMembership.SaveMembershipRoles() at EPiServer.UI.Edit.UserMembership.SaveButton_Click(Object sender, EventArgs e)
Does anyone got any ideas?
It turned out to be a collation problem.
The database did not have the same collation as the database server.
I tried to change collation with the SQL Server Management studio but it only changed the collation of the database and the tables, but NOT on the columns.
So I had to download a tool for changing collation on the column level.
After changing collation (everywhere) it works for me!
Same problem here on migrated database (4.62B -> 5 R2)
It turned out NOT to be a collation problem
But another interesting thing I found! The problem appeared with the users without e-mail or that the user had been registered more than once with the same e-mail.
I think migration program should have atleast raised a warnings flag...
Hopes this helps someone else with the same problem
Hi, has anybody else had this issue? I have the provider setup correctly, and no duplicate details, but I still get the error message when I try to add anyone to a role. Any other ideas? Would the colation thing be the issue in this case? How can you work out what the real error is?