How to solve the problem that the SQL Server user instance cannot be generated due to an error in starting the process of the user instance. The connection is closed.

Source: Internet
Author: User

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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.