I created sql database on one MSSQL2000 server and set up asp.net 2.0
security. Now I'm working on another computer. I moved all files and
backed up and restored database from old server to this new one.
When I try to add user using VS2005 Website ASP.NET Confiuguration I
got error. Still, user is added but not asigned to role. When I try to
asign it a role it doesn't work. Error that I get is related to server
collation. Old and new server have different collations, so my database
had also different collation than new server. I changed collation of my
database to be identical to server's but I still get error.
What to do?
This is error:
An error was encountered. Please return to the previous page and try
again.
The following message may help in diagnosing the problem: Cannot
resolve collation conflict for equal to operation. at
System.Web.Administration.WebAdminPage.CallWebAdmi nHelperMethod(Boolean
isMembership, String methodName, Object[] parameters, Type[]
paramTypes) at
ASP.security_users_adduser_aspx.UpdateRoleMembersh ip(String u, CheckBox
box) in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP. NETWebAdminFiles\Security\Users\addUser.aspx:line
61 at ASP.security_users_adduser_aspx.UpdateRoleMembersh ip(String u) in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP. NETWebAdminFiles\Security\Users\addUser.aspx:line
52 at ASP.security_users_adduser_aspx.CreatedUser(Object sender,
EventArgs e) in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP. NETWebAdminFiles\Security\Users\addUser.aspx:line
13 at
System.Web.UI.WebControls.CreateUserWizard.OnCreat edUser(EventArgs e)
at System.Web.UI.WebControls.CreateUserWizard.Attempt CreateUser() at
System.Web.UI.WebControls.CreateUserWizard.OnNextB uttonClick(WizardNavigationEventArgs
e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Obj ect source,
EventArgs e) at
System.Web.UI.WebControls.CreateUserWizard.OnBubbl eEvent(Object source,
EventArgs e) at
System.Web.UI.WebControls.Wizard.WizardChildTable. OnBubbleEvent(Object
source, EventArgs args) at
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) at
System.Web.UI.WebControls.Button.RaisePostBackEven t(String
eventArgument) at
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) at
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) at
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) at
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)