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.

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.

  1. Open SQL Server Configuration Manager. Navigation to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager

  2. Double-click SQL Server (SQLEXPRESS) and change it to use LocalSystem

  3. Delete the folder
    Windows Vista: C:Users[user]AppDataLocalMicrosoftMicrosoft SQL Server DataSQLEXPRESS
    Windows XP: c:Documents and Settings[user]Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS
    more info at: http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

That’s it.

Does that fix your problem?

Advertisements

0 thoughts on “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.

  1. “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.

    Like

  2. “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.

    Like

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

    Like

  4. 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. πŸ™‚

    Like

  5. 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. πŸ™‚

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s