First of all, I declare that this is the solution I have seen from others' blogs. It is not my original solution. I put it here for the sake of memo, and let other people who encounter the same problem and find the solution here. The original Article below is also from that blog.
Address: http://483sr2kpr3b9.spaces.live.com/blog/cns! 325744d898a71289! 326. Entry
I believe many people are using ASP. NET 2.0 + sql2005 + aspnetdb (membership and other functions) This problem occurs: "An error occurred while starting the process of the user instance, resulting in the failure to generate a user instance of SQL Server. The connection will be closed .", The error message for the same problem in the English version is: "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."
It took me nearly three days to finally find the answer! It turns out that this is Microsoft's bug, and Microsoft has admitted, details are as follows: http://support.microsoft.com /? Id = 896613
The condition for this error is that you have used Remote Desktop Connection and installed sql2005 + vs2005, which may trigger this problem, microsoft said it will solve this problem in the future xp sp3. To solve this problem immediately, you need to pay the fee ...... --6
Ignore Sb M $. We have our own solutions. Please refer to the following: Article : Http://forums.microsoft.com/MSDN/ShowPost.aspx? Postid = 128707 & siteid = 1
If you do not understand English, I will tell you the solution: delete C: \ Documents and Settings \ [username] \ Local Settings \ Application Data \ Microsoft SQL server data \ sqlexpress directory. [username] is the Windows user name, such as Administrator
To sum up, in order to prevent everyone from being as depressed as I do, I would like to share my experience with others. Thank you for your support ~
