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.

June 8, 2007

I had to uninstall and reinstall SQL server 2005 and Express on my development machine. After the un-installation, I reinstalled SQL 2005 standard then SQL Express. When I tried to open a SQL express database in VS2k5 I got the error “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.” After much searching, I found out the solution.

Open SQL Server Configuration Manager. Navigation to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager
Double-click SQL Server (SQLEXPRESS) and change it to use LocalSystem
Delete the folder
Windows Vista: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
Windows XP: c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
more info at: http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

That’s it.

Does that fix your problem?

Related Posts

Property Injection in ASP.NET MVC with Ninject
I got a design challenge with asp.net mvc. I want to keep track of the currently logged in user in...
SQL Script to generate data inserts for existing tables
Here is a great sql script that will look at your table and generate a script to insert all the data...
Unit Test Linq to Sql in ASP.Net MVC with Moq
I have just spent the entire day playing with Moq to unit test an asp.net mvc application I am worki...
Use ModelBinder to Generically Bind Complex Types
How to add a User Control to your WPF Window

kick it on DotNetKicks.com

Posted in SQL

Viewing 9 Comments

pipedings 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

GET A DECENT DATABASE, LIKE POSTGRES OR DB2.

reply edit reblog flag

lenin 5 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

No i tried your suggestion it didn't solve my problem.

reply edit reblog flag

response to pipedings 4 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

"GET A DECENT DATABASE, LIKE POSTGRES OR DB2"
Ignorance such as "Every thing that I do not know is bad", sometimes is blissful.
First learn to use all the three RDBMS and then talk.

reply edit reblog flag

Abdul Ghani 3 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

I still have the same problem and I dont know what mistake I am doing.

reply edit reblog flag

Abdul Ghani 3 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Please provide me with a solution I am really struct with this problem..

reply edit reblog flag

Thiago Barbedo 3 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Ibrahim thank you very much for helping me solve my problem. Very easy and simple solution.

reply edit reblog flag

Thanks! 3 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Thanks! solved my problem.

reply edit reblog flag

steen 3 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Hi!
It solved my problem. thanks!

reply edit reblog flag

Jon 4 weeks ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Great Advice!!!! Solved my problem as well!

reply edit reblog flag

Trackbacks

blog comments powered by Disqus