Saturday, 7 May 2011

"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 my fun with trying to get VS, SQL and Phone Tools all working together, I had the following error trying to mount databases:

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

If you get that error message, the solution that worked for me was to clear the SQL Express user instance data store, located at:

%userprofile%\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
(or full path)

C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

Hope this helps someone!

42 comments:

  1. Unknown19 August 2011 at 06:52

    thank you that's work for me

    ReplyDelete
    Replies
    1. Unknown15 August 2019 at 05:43

      toko kami menyediakan semua produk yang disebutkan diatas bahkan obat kuat pria herbal berasal dari cina maupun afrika langsung diimport agar menjaga kualitas dan keresmiannya, anda bisa memesan obat kuat secara online sehingga tidak kerepotan dengan cara menghubungi terlebih dahulu agen kami melalui kontak customer service, pertanyaan tentang produk obat kuat di cikampek dapat ditanyakan lewat sesi konsultasi.

      siapapun pria pastilah mendambakan bentuk kelamin besar apalagi panjang karena dianggap mampu memuaskan pasangan, untuk itulah banyak dari mereka mencari obat pembesar seperti vimax atau alat terapi terbaik seperti pro extender yang merupakan alat pembesar kelamin tanpa menimbulkan dampak negatif, alat tersebut dirancang secara profesional oleh dokter ternama asal canada dalam 2-3 bulan alat vital bertambah 3 inch lebih kalau pemakaiannya teratur.

      Delete
  2. Anonymous8 September 2011 at 03:46

    HI I like to share what I found.
    I tried what you and many of them said but I couldn't get it done properly. I worked with the .mdf database file not connect with the SQL Server so all I have done change the
    connection string to this

    @"Data Source=.;AttachDbFilename=" + Server.MapPath("~/DATABASE_NAME") + @";Integrated Security=True;Connect Timeout=30;User Instance=True";

    instead
    .\SQLEXPRESS
    I used this
    .
    then it worked. also it can be done with Server Explorer-> Add New Connection-> Select SQL Database File or something then go to Advance and replace .\SQLEXPRESS with . that's all.

    if someone has any trouble regarding this so this might be the solution for you if non of things worked.

    ReplyDelete
    Replies
    1. Ronny Kvist18 July 2012 at 21:42

      Thanks, works like a charm....

      Delete
    2. Anonymous6 November 2012 at 12:43

      still i can not create database. what can i do?

      Delete
  3. Anonymous14 December 2011 at 22:37

    Thanks, It was really helpful...

    ReplyDelete
  4. Anonymous26 December 2011 at 14:33

    Thanks. It worked just fine

    ReplyDelete
  5. Anonymous26 December 2011 at 14:33

    Thanks. It worked just fine

    ReplyDelete
  6. Anonymous31 December 2011 at 09:54

    Superb, that simple suggestion worked first time, all of the complicated ones from elsewhere didn't.

    Thank yoy.

    ReplyDelete
  7. Anonymous24 January 2012 at 20:35

    Thanks !your suggestion worked..

    ReplyDelete
  8. juni8 February 2012 at 16:18

    worked. thanks! :)
    but.. what did it do?

    ReplyDelete
  9. Anonymous28 February 2012 at 13:16

    thank u boss

    ReplyDelete
  10. Anonymous1 March 2012 at 08:01

    thank a lot

    ReplyDelete
  11. Anonymous5 March 2012 at 19:08

    thank you very much!
    it worked fine

    ReplyDelete
  12. Anonymous28 March 2012 at 08:02

    Appdata doesn't appear

    ReplyDelete
  13. Anonymous10 April 2012 at 23:35

    you da maan

    ReplyDelete
  14. Anonymous23 April 2012 at 08:28

    Wont let me modify it

    ReplyDelete
  15. Anonymous4 May 2012 at 21:36

    Worked fine for me. Thanks

    ReplyDelete
  16. Anonymous30 May 2012 at 17:06

    Worked well thnx

    ReplyDelete
  17. Gustavo14 June 2012 at 06:56

    Worked for me!! THX

    ReplyDelete
  18. Unknown29 June 2012 at 13:21

    Thank you very much...

    ReplyDelete
  19. Anonymous9 July 2012 at 11:17

    Gryphes, I did what you have told,but its showing the following error,

    "A network related or instance-specific error occured while establishing the connection to the SQL Server...."

    What shall I do now?

    ReplyDelete
  20. Anonymous9 July 2012 at 11:17

    William what shall be the full path for Windows XP?

    ReplyDelete
  21. Anonymous31 August 2012 at 17:38

    thank you very much... it worked:)

    ReplyDelete
  22. Anonymous29 September 2012 at 13:32

    it works!
    Thanks

    ReplyDelete
  23. Dan20 November 2012 at 15:23

    Worked for me! Thanks a lot! =)

    ReplyDelete
  24. unpeudetoutmontreal13 April 2013 at 19:56

    thank you it works !!

    ReplyDelete
  25. Anonymous12 August 2013 at 08:41

    Nice, thanks it worked.

    ReplyDelete
  26. Unknown22 December 2013 at 20:30

    thanks it helped for me

    ReplyDelete
  27. Khushbu Patel23 February 2014 at 12:05

    Can you anybody tell me how to create database in vs 2010 project inbuilt ?

    ReplyDelete
  28. Khushbu Patel23 February 2014 at 12:09

    How to create .mdf database in vs 2010 ?

    ReplyDelete
  29. Maulik Prajapati26 March 2014 at 06:19

    Thanks, It's Work successfully........

    ReplyDelete
  30. Anonymous28 May 2014 at 05:16

    worked, thanks!!

    ReplyDelete
  31. Anonymous7 April 2015 at 06:22

    its not working for me
    ....i have deleted the contents...bt still it is not working

    ReplyDelete
  32. Paulo30 October 2016 at 15:03

    There is an inclination to trust that loan specialists are fixated using a credit card scores, however this is untrue. We are cautioned about our record of loan repayment to urge us to keep up our reimbursement plans, however banks are more enthusiasm for different elements. Check Cashing San-diego

    ReplyDelete
  33. Unknown7 June 2018 at 07:08

    off white x jordan 1
    nmd
    hermes belts for men
    retro jordans
    yeezy boost 500
    nike shoes
    michael kors outlet
    nike polo shirts
    vibram five fingers
    stephen curry 5

    ReplyDelete
  34. mk5 October 2018 at 05:04

    Det finns flera stora och kända omnibus online-shoppingwebbplatser som Michael Kors Väska Rea. Dessa webbplatser är alla väldigt lättillgängliga och praktiska, de erbjuder Mikael Kors Väska med alla olika märken, stilar, priser och de kan strida mot de flesta köpare.

    (Läs källa: Michael Kors Plånbok,Michael Kors Väska Rea,Michael Kors Väska)

    För tjejer som vill ha speciella, ikoniska och högkvalitativa väskor från sina favoritdesigners, är det mest direkta och effektiva sättet att hitta den nyaste, hetaste och mest speciella designen på deras officiella webbplatser.

    (Läs källa: Sac Longchamp Femme,Sac Longchamp Pas Cher, Sac Longchamp Solde)

    Det finns verkliga butiker som säljer kvällssäckar på alla ställen, till exempel varuhus, designerbutiker eller sändningsaffärer. Fördelarna med att köpa i en butik är att du kan känna påsar i alla storlekar, du kan se om färgen matchar din klänning, eller om väskans storlek och vikt passar dina behov.

    (Läs källa: Michael Kors Bolsos,Bolsos Michael Kors Outlet,Bolsos Michael Kors Rebajas)

    ReplyDelete
  35. daysi25 January 2019 at 02:20

    cheap jerseys from china
    wholesale jerseys
    cheap nfl jerseys from china
    china jerseys
    cheap authentic nfl jerseys
    cheap jerseys online
    cheap authentic jerseys
    cheap sports jerseys
    cheap wholesale jerseys
    cheap authentic jerseys from china
    discount jerseys
    custom cowboys jersey
    nfl jerseys cheap
    cheap nfl jerseys china
    vintage football shirts
    jersey vip
    new football shirts
    old football shirts
    cheap football shirts
    football shirt
    jersey vip
    new football shirts
    football shirt culture
    vintage football shirts
    football shirt
    jersey vip

    ReplyDelete
  36. yu ge18 July 2019 at 11:36

    Coach Handbags Outlet are usually viewed as luxurious brands, but yet at inexpensive price.
    Today most people looking for COACH accessories will look for them at Coach Bags Factory Outlet.
    Coach Sale are just the most inexpensive items to purchase through Coach Purses Outlet, a small change purse or Cheap Coach Purses.
    Coach Bags On Sale are a fun accessory to add to a new collection.
    Coach Bags Outlet is can be carried or slipped over your shoulder.
    Authentic MK Outlet are made of high grade quality leather and Michael Kors Factory Outlet can actually have real leather on them.
    Michael Kors Purse Sale usually come with a plate bearing the MK Outlet logo to distinguish it from other Cheap Michael Kors Purses.
    Michael Kors Outlet Online have the inherent ability to capture the essence of what women like and what they want to wear and utilize.
    Michael Kors Outlet Store are a symbol of feminine elements and speak for all kinds of women.
    Michael Kors Purses On Sale of the day vary greatly, but all seem to share one characteristic, they are popular!

    ReplyDelete
  37. coach-handbags-clearance14 October 2020 at 09:24

    "We can't wait for the fall season and the chance to roll out our lineup of distinctive, innovative new dramas and comedies, scheduled with the kind of lead in support that will give each of our new shows the optimum chance to find their audiences Coach Bags Outlet and deliver on their outstanding potential," said Jennifer Salke, President, NBC Entertainment. "The fall lineup Michael Kors Outlet Store gives you only half the story. We truly program on a 52 week basis and are putting virtually the same amount of programming muscle behind our mid season lineup, with some of the most high profile concepts and biggest Coach Outlet Clearance names on television joining the schedule starting at midseason and extending throughout the remainder of the broadcast year.".

    Priyanka Chopra is beautiful and with that I just said one of the most redundant things ever. But we all know that behind those gorgeous looks, those public appearances, there is a team of stylists and beauticians who work hard to bring the best out of her. For celebrities, looking good is MK Outlet a full time occupation as Priyanka points out to New Yeezys 2020 Bazaar, she's "literally photographed every day." And it's Cheap Ray Ban Glasses not always in a celeb's control, what with the paparazzi, the shutterbugs, the phone cameras everywhere, you never know where you will get photographed and New Jordan Shoes 2020 Coach Bags Clearance make Nike Air Force 1 Cheap Outlet it to the headlines the next day.

    ReplyDelete
  38. yanmaneee6 November 2020 at 18:52

    supreme clothing
    goyard
    yeezys
    yeezy shoes
    yeezy
    supreme hoodie
    golden goose sneakers

    ReplyDelete

Subscribe to: Post Comments (Atom)