Hi,

When I submitted the survey, I got the following error
Failed to update database "C:\INETPUB\WWWROOT\SURVEYENGINE\APP_DATA\SURVEYDB .MDF" because the database is read-only.

when i tried to login as Admin or SuperAdmin with password# I get the following error:

Server Error in '/SurveyEngine' Application.
--------------------------------------------------------------------------------

Index was outside the bounds of the array.
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.IndexOutOfRangeException: Index was outside the bounds of the array.

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:


[IndexOutOfRangeException: Index was outside the bounds of the array.]
   System.Data.SqlClient.SqlDataReader.ReadColumn(Int 32 i, Boolean setTimeout) +808741
   System.Data.SqlClient.SqlDataReader.GetDateTime(In t32 i) +21
   System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
   System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
   System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
   System.Web.Security.SqlMembershipProvider.Validate User(String username, String password) +83
   System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e) +160
   System.Web.UI.WebControls.Login.AttemptLogin() +105
   System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e) +99
   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




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Sometimes the .mdf database file becomes read only. Right click that file, properties, uncheck the read only status, and click apply. Try it again?


Thanks,

Shawn Livermore
MCAD, MCSD, PMP
http://www.shawnlivermore.blogspot.com

I checked the .mdf file is not read only

There might be an issue with the aspnetdb.mdf file. You may want to try the following:

1. Delete the ASPNETDB database from the App_Data folder (both the MDF and LDF files)

2. Try to login in. This will fail, but a new ASPNETDB database will be created automatically in the App_Data folder.

3. Run the Website Administration Tool and create a new user called Admin (choose your own password) and a new Role called Admin.

4. Assign the new user to the Admin role.

5. Log in.

I think this should work; I know it worked for me....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

I don't understand why we would have to delete the aspnetdb, but it worked!

I was also getting an error when I used it through IIS. It was on the AppCode/Dal/SurveyDB.vb class. The line 99 throw was creating an error. I haven't read the section yet, so it was probably my mistake.

I think there's an issue with one of the stored procedures in the aspnetdb.mdf file that comes with the book.

When you delete the database file, .NET will automatically create a new one, based on a template on your local machine. This template database contains the correct procedures (developed by Microsoft for the ASP.NET features like Membership and Role manager) so your database ends up with the right versions as well.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Trilogy by Sonic Youth (Track 12 from the album: Daydream Nation) What's This?

Okay... how do you "Website Administration Tool" to create new Admin Account???

BTW... I already have a aspnetdb and log file setup in SQL2005 Express. I cannot log in at all.

Choose Website | ASP.NET Configuration in VWD.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.