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.

Fri, Jun 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?

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...
Startup – ASP.NET MVC, Cloud Scale & Deployment
Use ModelBinder to Generically Bind Complex Types

Tags: SQL

samfgdsfgdfgd

thanks a lot buddy....this works for windows 7 + sql 2008
jrock1000

I hoped but doubted it would be this simple, but it worked for me. I renamed the SQLEXPRESS folder however..
tinglebells

This did not help because I do not have a \local setting\applications directory in XP.

Thanks anyway.
tinglebells

NO - this is bogus.... there is no \local settings\application directory in my version of XT.
mostafa8026

thanks a lot............

:))

a lot
a lot
Judski

Weeee! Thanks a lot!! Really helped!!
Judi

Weee!! Thanks alot!! It solved my problem either.
mtom

awesome !! worked.. thx
srikanthganguly

Hey this is working...
Chumma.. ThnQ very much... Last time when i found this error.. I format my system...
srikanthganguly

Hey this is working.... ThnQ very much... Last time when i found this error.. i was help less and format the system.... chumma... :)
tjws

It worked like a charm! Thanks a lot
Tony

Thank you soooooo much, was about to rip my hair out
Richie

Excellent, thanks. Have seen many posts on other sites which didn't solve the problem because they missed out the ..\local settings\ folder in the path. :-)
frank

Thanks a lot.It works also with SQL Server 2008 Express and NetworkService instead of LocalSystem.
Shimmy

no!
doesn't fix!
den

Yes, thanks a lot !
Adam

Yes, yes, yes, thank very much !!!
Balachander

Thanks a lot .. Solved my prthis can be automated oblem. Wonder if this can be automated for the above error message !!
Greg Carter

yes ! it fixed it. thank you very much
adib

It works....Jazzakallah.
Jo

This absolutely worked. Thanks a lot.
M

also worked for me...thanks
TC

Tx worked first time.
Gotta love the Non SQL knobs
Paul Fleck

I have been fooling aroud with this all day. Thank you for posting this, it solved my problem.
Carl

Excellent. I recently installed SQL Server 2008 Express edition and ran into this same problem of getting the "Failed to generate a user instance of SQL Server..." message. I'm barely a novice, and wasted many hours fighting to find a solution to this problem. I'm very thankful your suggestion worked.
Jon

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

Hi!
It solved my problem. thanks!
Thanks!

Thanks! solved my problem.
Thiago Barbedo

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

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

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

"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.
lenin

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

GET A DECENT DATABASE, LIKE POSTGRES OR DB2.

Emad Ibrahim

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.

What I'm Doing...

Recent Posts

Yonkly Open Source

Sign up for my newsletter

megree Widget

Cyber Identity

Blogroll

DC

Tech