Failed to update database because the database is read-only | Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only in iis

Introduction:

Here I will explain how to solve the problem Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only during the time of publish application using asp.net.

Description:

I deployed one of my website in IIS and trying to test the application during that time I got error like this

Failed to update database "XXXXXXX\APP_DATA\DBSQAFTP.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 "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only.]    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857418    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735030

To solve this problem I did some configuration modifications for application folder check below steps

1.       1) Right-click on the folder where you have installed your application and select Properties.

2.       2) Click on the Security tab under that click on Edit button

3.       3) Now one window will open in that click on Add button to give permission for new user

4.       4) Once we click on Add new window will open like this in that Click on Locations and make sure your machine is selected and Type ASPNET in the text box and click on Check Names. ASPNET should underline (if it doesn't, then you don't have Microsoft's .NET framework installed).   

       5) Click OK. 

           6) After that select the account ASPNET check the Full Control box to give it full permissions. 

           7) Click OK.

After make all the modifications my application has worked successfully. I hope it helpful for the people who is in need with this problem.  

Happy Coding………

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email