我正在尝试使用sql Azure数据库使用SimpleMembership和MVC4.
我得到一个例外
- The Provider encountered an unknown error.
没有内部异常,在这行代码上:
- WebSecurity.CreateAccount("test@test.com","23iu$9835",false);
我的控制器上有这个过滤器
- [InitializeSimpleMembership]
其中包含此InitializeDatabaseConnection
- WebSecurity.InitializeDatabaseConnection("DefaultConnection","User","Id","Email",autoCreateTables: false);
我已经仔细检查了我的连接字符串,它似乎工作正常.
由于异常没有提供有用的信息,因此我很难调试此问题.有没有人有任何想法,为什么我可能有这个问题,或指出我正在开始调试问题的正确方向?
编辑:这是完整的堆栈跟踪:
- [MembershipCreateUserException: The Provider encountered an unknown error.]
- WebMatrix.WebData.SimpleMembershipProvider.CreateAccount(String userName,String password,Boolean requireConfirmationToken) +514
- WebMatrix.WebData.WebSecurity.CreateAccount(String userName,Boolean requireConfirmationToken) +75
- Nexus.Areas._Internal.Controllers.HomeController.Index() in c:\54Projects\Nexus\Nexus\Areas\_Internal\Controllers\HomeController.cs:38
- lambda_method(Closure,ControllerBase,Object[] ) +101
- System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller,Object[] parameters) +59
- System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext,IDictionary`2 parameters) +435
- System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext,ActionDescriptor actionDescriptor,IDictionary`2 parameters) +60
- System.Web.Mvc.Async.AsyncControllerActionInvoker.InvokeSynchronousActionMethod(ControllerContext controllerContext,IDictionary`2 parameters) +50
- System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +75
- System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +44
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +139
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +102
- System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +49
- System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +126
- System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +323
- System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +323
- System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +44
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +139
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +102
- System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +50
- System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +68
- System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +184
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +136
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +56
- System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +40
- System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +40
- System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +47
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +151
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +59
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +40
- System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +44
- System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +47
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +151
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +40
- System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +39
- System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +39
- System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +45
- System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +47
- System.Web.Mvc.Async.WrappedAsyncResult`1.End() +151
- System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,Object tag) +40
- System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +40
- System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +38
- System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9628700
- System.Web.HttpApplication.ExecuteStep(IExecutionStep step,Boolean& completedSynchronously) +155
解决方法
试试这个
- WebSecurity.CreateUserAndAccount("test@test.com",false);