Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to parse user instances that cannot generate SQL Server due to errors in starting the user instance process. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Due to an error in starting the process of the user instance, the user instance of SQL Server cannot be generated _ the connection will be closed

When installing the module of VS2008 developing DNN in win7, there is often the problem that "the user instance of SQL Server cannot be generated due to an error in starting the process of the user instance. The connection will be closed". There are the following solutions on the Internet

I believe many people have this problem when using ASP.NET 2.0 + SQL2005 + netdb (MemberShip and so on):

"the user instance of SQL Server could not be generated due to an error starting the process of the user instance. The connection will be closed."

The error message for the same question 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 3 days to finally find the answer! It turns out that this is Microsoft's bug, and Microsoft has admitted that the details are as follows:

Http://support.microsoft.com/?id=896613

The user instance of SQL Server could not be generated due to an error in starting the process of the user instance. The connection will be closed.

Solution: delete the directory C:\ Users\ Administrator\ AppData\ Local\ Microsoft\ Microsoft SQL Server Data\ SQLEXPRESS

The above method is useful in xp and can be done as follows under win7

End the sqlserver process in the process manager.

Set "C:\ Users\ Classic .NET AppPool\ AppData\ Local\ Microsoft\ Microsoft SQL Server Data\"

The SQLEXPRESS directory is deleted.

After reading the above, do you have any further understanding of how to resolve a user instance that cannot generate SQL Server due to an error in starting the process of starting the user instance? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.