Wednesday, 15 September 2010

asp.net mvc 4 - Cannot update the database (LocalDB) -



asp.net mvc 4 - Cannot update the database (LocalDB) -

i have written application in code-first approach (asp.net mvc), , trying deploy application on server (windows server 2012). when test in visual studio 2013 web goes fine. after implementation, when access website web, cannot illustration add together next user because:

failed update database "mydatabase" because database read-only.

i checked instances in localdb folder, , read-only. alter of in properties menu doesn't work. stack tree:

[sqlexception (0x80131904): failed update database "mydatabase" because database read-only.] system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection, action1 wrapcloseinaction) +388 system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj, boolean callerhasconnectionlock, boolean asyncclose) +815 system.data.sqlclient.tdsparser.tryrun(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj, boolean& dataready) +4515 system.data.sqlclient.sqlcommand.finishexecutereader(sqldatareader ds, runbehavior runbehavior, string resetoptionsstring) +6553853 system.data.sqlclient.sqlcommand.runexecutereadertds(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, boolean async, int32 timeout, task& task, boolean asyncwrite, sqldatareader ds) +6556619 system.data.sqlclient.sqlcommand.runexecutereader(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, string method, taskcompletionsource1 completion, int32 timeout, task& task, boolean asyncwrite) +586 system.data.sqlclient.sqlcommand.internalexecutenonquery(taskcompletionsource1 completion, string methodname, boolean sendtopipe, int32 timeout, boolean asyncwrite) +742 system.data.sqlclient.sqlcommand.executenonquery() +287 webmatrix.data.database.execute(string commandtext, object[] args) +178 webmatrix.webdata.simplemembershipprovider.checkpassword(idatabase db, int32 userid, string password) +455 webmatrix.webdata.simplemembershipprovider.validateuser(string username, string password) +238 webmatrix.webdata.websecurity.login(string username, string password, boolean persistcookie) +73 mvcapplication4.controllers.accountcontroller.login(loginmodel model, string returnurl) +132 lambda_method(closure , controllerbase , object[] ) +179 system.web.mvc.reflectedactiondescriptor.execute(controllercontext controllercontext, idictionary2 parameters) +258 system.web.mvc.controlleractioninvoker.invokeactionmethod(controllercontext controllercontext, actiondescriptor actiondescriptor, idictionary`2 parameters) +39 system.web.mvc.async.<>c__displayclass42.b__41() +34 system.web.mvc.async.<>c__displayclass39.b__33() +124 system.web.mvc.async.<>c__displayclass4f.b__49() +786611 system.web.mvc.async.<>c__displayclass4f.b__49() +786611 system.web.mvc.async.<>c__displayclass37.b__36(iasyncresult asyncresult) +15 system.web.mvc.async.<>c__displayclass2a.b__20() +33 system.web.mvc.async.<>c__displayclass25.b__22(iasyncresult asyncresult) +787092 system.web.mvc.<>c__displayclass1d.b__18(iasyncresult asyncresult) +28 system.web.mvc.async.<>c__displayclass4.b__3(iasyncresult ar) +15 system.web.mvc.controller.endexecutecore(iasyncresult asyncresult) +65 system.web.mvc.async.<>c__displayclass4.b__3(iasyncresult ar) +15 system.web.mvc.controller.endexecute(iasyncresult asyncresult) +51 system.web.mvc.<>c__displayclass8.b__3(iasyncresult asyncresult) +42 system.web.mvc.async.<>c__displayclass4.b__3(iasyncresult ar) +15 system.web.mvc.mvchandler.endprocessrequest(iasyncresult asyncresult) +51 system.web.callhandlerexecutionstep.system.web.httpapplication.iexecutionstep.execute() +606 system.web.httpapplication.executestep(iexecutionstep step, boolean& completedsynchronously) +288

since sqlexpress db, take @ answer. looks same issue having.

failed update .mdf database because database read-only (windows application)

update

for .mdf , .idf files, give write , modify access network service user, aspnet user, , iis_iusrs group.

database asp.net-mvc-4 web web-deployment localdb

No comments:

Post a Comment