CODEWITHSUNDEEP
c#.netasp.net
Attilah
Attilah

Reputation: 17932

Failed to update database because it is read-only

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. "

Upvotes: 7

Views: 14763

Answers (6)

cheny
cheny

Reputation: 2735

I followed Attilah's answer and found: 1. Both IIS-ISUR, WebService had full pomission to the App_Data and the mdf. 2. But someone called "asp.net 4.0 pool" and "all users" did not, so I allowed them.

Then 3. I followed user1280392's answer to run "iisreset" but failed (but still run it pls).

Then I went to IIS manager and did this: 4. Clicked the server's name, clicked "restart" on the right. 5. Clicked the applications name, clicked "restart" on the right.

and it was ok.

Upvotes: 1

user1280392
user1280392

Reputation:

Don't forget to restart the IIS with "iisreset.exe" after altering the permissions

Upvotes: 5

Attilah
Attilah

Reputation: 17932

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.

Upvotes: 11

Greg Andora
Greg Andora

Reputation: 1372

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.

Upvotes: 2

Oded
Oded

Reputation: 499382

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.

Upvotes: 1

Tom Tresansky
Tom Tresansky

Reputation: 19877

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.

Upvotes: 2

Related Questions