Please help

Question

User1914678174 posted

hihi everyone

After i've finished the website using VWD 2005 Express Edition, i copied the entired folder include .cs file and then browse it in IIS. But during browsing error occured when i try to access the login....

Failed to update database "C:\NEW FOLDER\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:\NEW FOLDER\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Did I miss configure something... or is cause by other reason.... some one pls help me 4this

Beside that, I heard from my friend that it is able to deploy website with dll and without the .cs file. But I cant found any dll file in my website folder. Can anyone please teach me how to generate those dll files. 

Thanks. 

Answer 1

User-837620913 posted
Try this:

1. Detach aspnetdb database from SQLEXPRESS using sseutil.exe utility.
2. Remove *.mdf and *.ldf files from App_Data application directory
3. Grant Read/Write access on App_Data to working process identity (ASPNET for IIS5.X or NETWORK SERVICE for IIS6)
4. Copy *.mdf, *.ldf files back into App_Data folder
5. Run application, refresh if any connection related error received

Answer 2

User1914678174 posted

hello,

first i wanna thanks for your helping but.... can i know what is sseutil.exe and where can i found it.... sorry for asking that coz i'm new in asp.net

beside that can you please teach me what is the best method i can used for deploying a website in VWD 2005 express edition..... coz some information that i found on web can be apply on VWD 2005 express edition....

 

Answer 3

User-1391746795 posted
This might help

http://forums.asp.net/906004/ShowPost.aspx

Answer 4

User1914678174 posted
sorry.... i still can slove the problem....

can someone please provide a detail solution.....

please.... (crying)...........

Answer 5

User-1391746795 posted

1.  Delete the MDF/LDF files from the App_Data directory of the website under inetpub\wwwroot. 
2.  Download and install the SSEUTIL command line tool from:
      http://www.microsoft.com/downloads/details.aspx?FamilyID=FA87E828-173F-472E-A85C-27ED01CF6B02&displaylang=en
3.  Using sseutil, issue a command that looks something like:  sseutil -child "NT AUTHORITY\NETWORK SERVICE" -detach D:\  .  You will need to change the account name and the detach path to match your machine settings.  If on IIS5/5.1, then ASPNET will be the correct user account.  Also, you can determine the detach path pretty easily by issuing sseutil -list to see where the problematic MDFs are currently attached.  The "D:\" in the sample command line is just the first few characters that sseutil uses to auto-detach all databases that begin with "D:\".  Change the path as neeeded for your machine.
4.  Set the ACLs on App_Data directory under inetpub\wwwroot to grant R/W to the appropriate process account - NETWORK SERVICE on Windows Server 2003 or ASPNET on IIS5/5.1 (Windows XP).
5.  Re-copy the MDF/LDF files from the directory where the file-based website exists back into App_Data under inetpub\wwwroot.  After the copy occurs, check that the MDF/LDF files have now inherited the new ACLs.
6.  Re-run the application (ignore any connection errors that might occur - just hit refresh in the browser).

This steps are very easy to follow. Which step is not working for you ?

Khaled

Answer 6

User1914678174 posted
hello khaled and all,

thanks for your help.... finally the problem(cannot update databased) have solve and the website was successfully browse in local IIS which machine is windowXP pro.... then i copy the entired folder to a window 2003 server but at server there.... during browsing on the IIS.... i can't login and error message(timeout - server not responding) occur....

anyone know about this.... thanks
 

Answer 7

User-1858423312 posted

I do need your help, many thanks.  I downloaded SSEUtil,exe, but failed to load the command prompt. The error message I got is : SSEUtil.exe - Net Framework initializtion error. Unable to find the version of runtime to run the application. Any thoughts about it?

Answer 8

User1317848875 posted

Hello,

Just wanted to let you know that there is an alternative to using SSEUtil.exe, you can just go the services.msc (in run command) and stop the SQLEXPRESS service, remove the files, grant the access, put the files back and start the service.

It worked for me.

Thanks.