Database file and folder are not read only but error message says it is read only??

K

keithb

This is on a remote server. Everything works in the development
envirmonment. Any ideas?

Thanks,

Keith

Failed to update database "C:\BTM_ROOT\APP_DATA\ASPNETDB.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:\BTM_ROOT\APP_DATA\ASPNETDB.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
"C:\BTM_ROOT\APP_DATA\ASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
+886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.ResetPassword(String username,
String passwordAnswer) +2226
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer)
+83
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer,
Boolean useAnswer, Boolean throwOnError) +34
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPasswordQuestionView()
+352
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPassword() +66
System.Web.UI.WebControls.PasswordRecovery.OnBubbleEvent(Object source,
EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
+163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
 
K

Ken Cox [Microsoft MVP]

Hi Keith,

Did you check that the ASPNET account (or whatever ASP.NET is running as)
has sufficient permissions in the folder to create the .ldf file.

Trying giving the account Full Control over the App_Data folder and then
restart IIS.

Let us know?

Ken
Microsoft MVP [ASP.NET]



keithb said:
This is on a remote server. Everything works in the development
envirmonment. Any ideas?

Thanks,

Keith

Failed to update database "C:\BTM_ROOT\APP_DATA\ASPNETDB.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:\BTM_ROOT\APP_DATA\ASPNETDB.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
"C:\BTM_ROOT\APP_DATA\ASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734854

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
+886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.ResetPassword(String username,
String passwordAnswer) +2226
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer)
+83
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer,
Boolean useAnswer, Boolean throwOnError) +34

System.Web.UI.WebControls.PasswordRecovery.AttemptSendPasswordQuestionView()
+352
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPassword() +66
System.Web.UI.WebControls.PasswordRecovery.OnBubbleEvent(Object source,
EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument) +163

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
 
K

keithb

That was it.

Many thanks

Keith

Ken Cox said:
Hi Keith,

Did you check that the ASPNET account (or whatever ASP.NET is running as)
has sufficient permissions in the folder to create the .ldf file.

Trying giving the account Full Control over the App_Data folder and then
restart IIS.

Let us know?

Ken
Microsoft MVP [ASP.NET]



keithb said:
This is on a remote server. Everything works in the development
envirmonment. Any ideas?

Thanks,

Keith

Failed to update database "C:\BTM_ROOT\APP_DATA\ASPNETDB.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:\BTM_ROOT\APP_DATA\ASPNETDB.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
"C:\BTM_ROOT\APP_DATA\ASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734854

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.ResetPassword(String
username, String passwordAnswer) +2226
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer)
+83
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer,
Boolean useAnswer, Boolean throwOnError) +34

System.Web.UI.WebControls.PasswordRecovery.AttemptSendPasswordQuestionView()
+352
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPassword() +66
System.Web.UI.WebControls.PasswordRecovery.OnBubbleEvent(Object source,
EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument) +163

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+5102
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,731
Messages
2,569,432
Members
44,835
Latest member
KetoRushACVBuy

Latest Threads

Top