Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.

This is a very strange issue that I have. I am glad that a solution was out there. I got this error when I used Visual Studio Web Developer Web access the database file. After doing some research, it turns out that it is a bug in the OS. http://support.microsoft.com/Default.aspx?id=896613 Basically I remote log on to my computer, and because I am a remote user, I can't access the database file. However, if I log on the the computer locally first, and then remotely log on to it, there is no problem.

ASP .NET Issue: Failed to update database XXX because the database is read-only

Story (Skip this part if you want the solution) Since I don't have a job and have quiet a bit of free time, I started playing around ASP .NET 2.0 and setting up my own webpage. At the same time, I was investigating how to setup a ASP DetailsView Control because it is extremely useful if you want your webpage to be dynamically data-driven. I have two machines at home. The faster computer, which sit in my room is used for my daily computer activities and software development (non-work related), and the 2nd computer which is only a Pentium 800 runs an IIS server. After I design and tested the ASP DetailsView control on the development machine and tested it locally, I copy the files to the IIS server. Loading the information from the DetailsView doesn't have any problem, but when I update the content. this is what I got:

Solution: I know that this has to do with some security issue, but I was thinking it is something due with SQL connection string. But lucky someone has find a solution that works for me: Tjitjing Blog

1. Make sure your database .MDF and its corresponding log file LDF is not read only. These file usually stored in your App_Data project folder .
2. Right Click and select property of your App_Data folder.
3. Under Security tab, add ASP .NET and NETWORK SERVICE users, and allow Modify permission. Apply the setting
4. Restart you IIS - you can go to your IIS mmc console, right click on your IIS Server (in my case it is the local computer), select All Tasks->Restart IIS. (IIS ver. 5.1)

Then test your web page to see if it works.

ASP .NET IIS Configuration Error

Ahhhh.... took me so long to fix this error:

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. Source Error:

Line 10:   
Line 11:   
Line 12:   
Line 13:    
Line 14:   

...
..
.

Well, it turns out that I was accessing
http://localhost:9007/DickyWebsite/Default.aspx
while the actual path is
http://localhost:9007/Dicky%20Website/Default.aspx

YES, it is this extra space that I added when I set up the Virtual Directory.

I am still new to IIS and web.config file. Hopefully I won't encounter anything like that again... of course I will, we are doing programming!