Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Database file and folder are not read only but error message says it is read only??

Reply
Thread Tools

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

 
 
keithb
Guest
Posts: n/a
 
      06-07-2006
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




 
Reply With Quote
 
 
 
 
Ken Cox [Microsoft MVP]
Guest
Posts: n/a
 
      06-07-2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>
>



 
Reply With Quote
 
 
 
 
keithb
Guest
Posts: n/a
 
      06-07-2006
That was it.

Many thanks

Keith

"Ken Cox [Microsoft MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
Issue with importing CSV file using JET. Error Message: 'Cannot update. Database or object is read-only. ' tom ASP .Net 1 07-13-2009 02:38 PM
adapter preview-data succeeds, but ASPX page says 'Cannot open database' bennett@peacefire.org ASP .Net 1 01-11-2006 04:47 AM
Dell says no & Acronis says maybe sysprep utility ( Re: Anyone use Acronis Drive Image 7.0? Bobby Fischler Computer Support 0 07-24-2004 12:12 AM
For share a folder in the network , but the folder only allow by password holder MCSE 55 04-14-2004 11:56 PM



Advertisments