"Database is read-only" Exception

Question

Server Error in '/' Application.

i tried all the things but im unable to write to database from another pc i am able to read but not able to write any solution ?

Failed to update database "C:\INETPUB\WWWROOT\APP_DATA\REPORT_DB.MDF" because the database is read-only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:\INETPUB\WWWROOT\APP_DATA\REPORT_DB.MDF" because the database is read-only.

Source Error: 


Line 29:       cmd.Parameters.AddWithValue("@paswd", paswd);
Line 30:       cmd.Parameters.AddWithValue("@name", name);
Line 31:       cmd.ExecuteNonQuery();
Line 32:       con.Dispose();
Line 33:

Dustin Laine · Accepted Answer · 2011-03-22 05:33:07Z

1

You need to navigate to that file, right click and select properties. Then uncheck the read only flag. It is simply the file permissions of the MDF file.

answered Mar 22, 2011 at 5:33

Dustin Laine

38.7k10 gold badges90 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sajoshi · Accepted Answer · 2011-03-22 05:33:05Z

1

Go to App_Data folder and uncheck the readonly attribute from file REPORT_DB.MDF

answered Mar 22, 2011 at 5:33

sajoshi

2,7631 gold badge18 silver badges22 bronze badges

Comments

Janusz Grabis · Accepted Answer · 2012-04-26 15:03:24Z

1

I had the same kind of error ("Attempt to write a read-only database") after moving my app from XSP to IIS. I was missing Write permission for ASP.NET user on my database file. After adding that persmission everything started to work.

answered Apr 26, 2012 at 15:03

Janusz Grabis

1741 silver badge10 bronze badges

Comments

Kamran Khan · Accepted Answer · 2011-03-22 05:35:44Z

0

See that:

Your aspnet user has the modify rights on your App_Data folder
Check the file read/write attribute; right click and see if its not marked as readonly.

answered Mar 22, 2011 at 5:35

Kamran Khan

9,9842 gold badges33 silver badges41 bronze badges

Collectives™ on Stack Overflow

"Database is read-only" Exception

Server Error in '/' Application.

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Server Error in '/' Application.

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related