Home > 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
  1. No comments yet.
  1. No trackbacks yet.