Failed to update database because it is read-only

Question

I have set up my website to use ASP.NET Membership. it all works fine when trying to use it on my development machine but when I put it on the web server and try to log in, I get this error :

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

Answer 1

The user account that the website is running under needs write permissions on the file.

It is also likely that the file is read-only as result of the transfer and needs to be set to be writeable.

Answer 2

Is the file readonly? Does the asp user account have permissions to write to the directory the database is in?

Answer 3

Check that file on the disk. Right click and go to properties.

If it is a read-only file, you will need to make it writeable.

Answer 4

If the file is read-only and you can't seem to change it using the Properties window, you have to use a command prompt.

Refer to this Support article at Microsoft.

Answer 5

Hi All, thanks for the help. I just found a solution. in the App_Data ACL, I had two entries : Network Service and IIS_IUSRS. the Network Service account had full permissions but IIS_IUSRS group had only read access. so, I gave IIS_IUSRS full permissions as well and it worked !

thanks again.