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

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(SqlExc eption exception,
Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.ResetPas sword(String username,
String passwordAnswer) +2226
System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer)
+83
System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer,
Boolean useAnswer, Boolean throwOnError) +34
System.Web.UI.WebControls.PasswordRecovery.Attempt SendPasswordQuestionView()
+352
System.Web.UI.WebControls.PasswordRecovery.Attempt SendPassword() +66
System.Web.UI.WebControls.PasswordRecovery.OnBubbl eEvent(Object source,
EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument)
+163
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

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

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" <kbrickey@dslextreme.com> wrote in message
news:ekMIl7ciGHA.4304@TK2MSFTNGP03.phx.gbl...
> 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(SqlExc eption exception,
> Boolean breakConnection) +857242
> System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection) +734854
>
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj) +188
> System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
> cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj) +1838
> System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
> RunBehavior runBehavior, String resetOptionsString) +149
> System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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.InternalExecuteNo nQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe) +415
> System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
> System.Web.Security.SqlMembershipProvider.ResetPas sword(String username,
> String passwordAnswer) +2226
> System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer)
> +83
> System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer,
> Boolean useAnswer, Boolean throwOnError) +34
>
> System.Web.UI.WebControls.PasswordRecovery.Attempt SendPasswordQuestionView()
> +352
> System.Web.UI.WebControls.PasswordRecovery.Attempt SendPassword() +66
> System.Web.UI.WebControls.PasswordRecovery.OnBubbl eEvent(Object source,
> EventArgs e) +101
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +35
> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
> System.Web.UI.WebControls.Button.RaisePostBackEven t(String
> eventArgument) +163
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
> eventArgument) +7
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
> sourceControl, String eventArgument) +11
> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
>
>
>
>

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

That was it.

Many thanks

Keith

"Ken Cox [Microsoft MVP]" <BANSPAMkjopc@newsgroups.nospam> wrote in message
news:OofOKpdiGHA.4304@TK2MSFTNGP03.phx.gbl...
> 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" <kbrickey@dslextreme.com> wrote in message
> news:ekMIl7ciGHA.4304@TK2MSFTNGP03.phx.gbl...
>> 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(SqlExc eption exception,
>> Boolean breakConnection) +857242
>> System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
>> exception, Boolean breakConnection) +734854
>>
>> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
>> stateObj) +188
>> System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
>> cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> bulkCopyHandler, TdsParserStateObject stateObj) +1838
>> System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
>> RunBehavior runBehavior, String resetOptionsString) +149
>> System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(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.InternalExecuteNo nQuery(DbAsyncResult
>> result, String methodName, Boolean sendToPipe) +415
>> System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
>> System.Web.Security.SqlMembershipProvider.ResetPas sword(String
>> username, String passwordAnswer) +2226
>> System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer)
>> +83
>> System.Web.Security.MembershipUser.ResetPassword(S tring passwordAnswer,
>> Boolean useAnswer, Boolean throwOnError) +34
>>
>> System.Web.UI.WebControls.PasswordRecovery.Attempt SendPasswordQuestionView()
>> +352
>> System.Web.UI.WebControls.PasswordRecovery.Attempt SendPassword() +66
>> System.Web.UI.WebControls.PasswordRecovery.OnBubbl eEvent(Object source,
>> EventArgs e) +101
>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> +35
>> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
>> System.Web.UI.WebControls.Button.RaisePostBackEven t(String
>> eventArgument) +163
>>
>> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
>> eventArgument) +7
>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
>> sourceControl, String eventArgument) +11
>> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
>> System.Web.UI.Page.ProcessRequestMain(Boolean
>> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>> +5102
>>
>>
>>
>>
>
>