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!

27 comments:

  1. thank you that's work for me

    ReplyDelete

  2. 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. Thanks, works like a charm....

      Delete

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

      Delete

  3. Thanks, It was really helpful...

    ReplyDelete

  4. Thanks. It worked just fine

    ReplyDelete

  5. Thanks. It worked just fine

    ReplyDelete

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

    Thank yoy.

    ReplyDelete

  7. Thanks !your suggestion worked..

    ReplyDelete

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

    ReplyDelete

  10. thank a lot

    ReplyDelete

  11. thank you very much!
    it worked fine

    ReplyDelete

  12. Appdata doesn't appear

    ReplyDelete
    Replies

    1. check inside admin

      Delete

  13. you da maan

    ReplyDelete

  14. Wont let me modify it

    ReplyDelete

  15. Worked fine for me. Thanks

    ReplyDelete

  16. Worked well thnx

    ReplyDelete

  17. Worked for me!! THX

    ReplyDelete

  19. 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. William what shall be the full path for Windows XP?

    ReplyDelete

  21. thank you very much... it worked:)

    ReplyDelete

  22. it works!
    Thanks

    ReplyDelete

  23. Worked for me! Thanks a lot! =)

    ReplyDelete

Subscribe to: Post Comments (Atom)