I am having a problem running the downloads.
Each time I try running any of the applications it generates an error.
Please help me out.

Server Error in '/OnlineDiary' Application.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
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 generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

Source Error:

Line 214: sqlCmd.Parameters.AddWithValue("@DiaryId", DiaryId)
Line 215:
Line 216: diaryDBConn.Open()
Line 217: Dim entrySQLDR As SqlDataReader = sqlCmd.ExecuteReader(CommandBehavior.CloseConnecti on)
Line 218: sqlCmd = Nothing


Source File: D:\Documents and Settings\Administrator\My Documents\Mybooks\OnlineDiary\App_Code\DiaryEntry. vb Line: 216

Hi there,

Did you change the security settings for the App_Code folder? Your webserver account (either you, or ASPNET or Network Service) needs write permissions to this folder.

And how is your SQL Server installation called? Is it called SqlExpress or does it have a different name?

Also, try moving the site to something like c:\Inetpub\wwwroot\MyBooks.

It'll be easier to configure the site from there.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
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.

Thanks Imar,
I moved the directory to D:\Inetpub\wwwroot.
I also enabled write permission for the App_code folder and the App_data folder.
But I still get the same Error.
I also noticed that when I type localhost/Onlinediary the browser returns

Directory Listing Denied
This Virtual Directory does not allow contents to be listed.
The SQLserver express came installed with VS 2005 Professional.
It is called SQLEXPRESS.

Thanks
I already got the files running.

Hi there,

Glad it's working now. For the benefit of the archive, would you mind sharing how you fixed it?

Imar
---------------------------------------
Imar Spaanjaars
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.