Home > HowTos, Server Administration > How To: Fix database access permission on IIS

How To: Fix database access permission on IIS

January 30th, 2010 Leave a comment Go to comments

Issue:

When deploying your web application to IIS that uses SQL Express database, you get an error stating that “Failed to update database ‘APP_DATA\XXXX.MDF’ because the database is read-only”.

Here’s how you can fix it:

  1. Make sure App_Data directory or any contained files does not have file system attribute Read-only set.
  2. Give user ASPNET and NETWORK SERVICE Modify control over the App_Data directory.
  3. Run IISRESET to restart IIS to refresh its permissions
Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
  • Live
  • MySpace
  • RSS
  • Technorati
  • Twitter
  1. No comments yet.
  1. No trackbacks yet.