Failed to update database: "APP_DATA\ASPNETDB.MDF" is read-only on host site RSS

• • Reply
  

  panwt

  Member

  54 Points

  16 Posts

  Failed to update database: "APP_DATA\ASPNETDB.MDF" is read-only on host site

  Jun 23, 2005 02:56 PM|LINK

  There is no problem for me to run the site locally. I've created admin locally using ASP.Net Configuration. I've also deployed it to CrystalTech, there's no problem for me to browse the site as well. But, when I tried to login as admin, error showed as below. Do I need to do something like SSEUTIL command on my local machine first? Can someone help me with this? Thanks a lot!
  
  Brian
  
  
  

  Failed to update database "D:\INETPUB\DOMAINID101357\APP_DATA\ASPNETDB.MDF" because the database is read-only.

  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
  
  Exception Details: System.Data.SqlClient.SqlException: Failed to update database "D:\INETPUB\DOMAINID101357\APP_DATA\ASPNETDB.MDF" because the database is read-only.
  
  Source Error:
  
  

  An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

  
  Stack Trace:
  
  

  [SqlException (0x80131904): Failed to update database "D:\INETPUB\DOMAINID101357\APP_DATA\ASPNETDB.MDF" because the database is read-only.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +786226 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684838 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1751 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +107 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +570 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +134 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +646 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +78 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +161 System.Web.UI.WebControls.Login.AttemptLogin() +94 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +146 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5670

• • Reply
  

  DarrellNorto...

  All-Star

  86809 Points

  9646 Posts

  Moderator

  MVP

  Re: Failed to update database: "APP_DATA\ASPNETDB.MDF" is read-only on host site

  Jul 06, 2005 12:10 PM|LINK

  I just answered a similar question here.  See if that helps any.
  
  Darrell Norton, MVP
  Darrell Norton's Blog
  Please click "Mark as Answer" if this helped you.
• • Reply
  

  JamesManhatt...

  Member

  22 Points

  29 Posts

  Re: Failed to update database: "APP_DATA\ASPNETDB.MDF" is read-only on host site

  Jul 29, 2008 09:33 AM|LINK

  I had the same problem at bringing the website to server, and after trying every 'wise' fix I could find on Google, I thought to myself how about if I just reboot the server (had been running for months without a reboot) - that did it. Magically, the reboot opened the database.
  Prior to reboot I gave  NETWORK SERVICE Modify control over the App_Data directory - I'm not sure if that made a differance, but so you all know, that error bitch is out....