#Google Analytic Tracker


Jan 27, 2007

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.

Jan 24, 2007

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
while the actual path is

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!