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
An error occurred while starting the process of the user instance. As a result, the user instance of SQL Server cannot be generated. The connection is closed.
Solution: Delete the directory c: \ Users \ Administrator \ appdata \ Local \ Microsoft SQL server data \ sqlexpress.
I personally use vs2010 + win7 + sqlserver2008 + SSMs to delete c: \ Users \ syx \ appdata \ Local \ Microsoft SQL server data \ sqlexpress, and sqlexpress directories, I personally think it is okay to find the sqlexpress directory and delete it!
From: http://www.cnblogs.com/syxchina/archive/2010/11/01/2197342.html