In iis the asp.net website retrieves data from sql server database, but not update

• mosuliis

  Grasshopper

  Points: 19

  More actions

  December 13, 2011 at 2:27 am

  #391113

  Hi!

  I'm Mosuli Nodangala, I have a problem with a deployed asp.net website. I deployed this website in the iis, the worst thing is that it can retrieves data from database, but when I press button Add it displays this error

  :Failed to update database "C:\INETPUB\WWWROOT\WEBSETUP111\APP_DATA\INFO_DB.MDF" because the database is read-only.

  I need help, what should I do to remove a read-only attribute from the database

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 13, 2011 at 2:35 am

  #1420444

  To solve this issue do the following:

  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.

  For More: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/577ba01d-e31c-4690-9e0c-4cdd7c43b787/