SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed

Just a day ago, I was installing SQL Server Express on backup computer. I only use this computer when I have something to experiment. While installing SQL Server Express I found following error in my error log which prevented successful installation to computer. It was difficult to initially understand the problem by itself, after some try and error I found the solution.

Error: 15372, Severity: 16, State: 1.
Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance.  The connection will be closed.

Solution for this error is fairly simple.

Fix/Workaround/Solution:

For XP:
Delete the directory “c:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS “

For Vista:
Delete the directory “c:\Users\<username>\AppData\Local\Microsoft\Microsoft Sql Server Data\SQLEXPRESS”

Reboot the system.

Watch SQL in Sixty Seconds video to Resolve Connection Error:

Reference : Pinal Dave (http://blog.sqlauthority.com)


About these ads

19 thoughts on “SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed

  1. Thanks for your this information. This will very help to resolve the issue if we tried to install again on a machine which content a installation of SQL Server and because of some reason it was crashed.

  2. Question: What is this folder doing here in the first place and why does deleting it resolve this issue?? Just curious. I looked for a solution for a long time before I found your post here. It was very frustrating. One day my program is working, the next day when I open it, I cannot connect to my database instance because of this error. I would like to know where this problem occurred and why.

    Thanks

    Kat

  3. Rebooting my system is what causes this problem (almost every time) — so if “reboot the system” is part of the proposed solution, I’m probably screwed.

    I’ve wasted hours and hours (30m-2h per reboot) on this problem. Sometimes this “delete the directory” works, but not today.

    I really wish I’d started this project, I’d have avoided MS crap altogether (LAMP vs. MS.NET+MSSQL), but at this point it’d take 200 hours to convert.

    But then within 6 months, I’ll have wasted 50 just trying to get SQLExpress to reconnect after the weekly patch/reboot.

  4. Hi Pinal Dave

    From the one day to the next I got this error you are describing above. I tried your solution, and hey man! It worked! But it could actually be interesting to know why the error arose? Because as far as I know I didn’t do anything wrong before I started getting this error.

    Anyway you solved my problem, therefore you are cool!

    Regards

    Rune in Copenhagen, Denmark

  5. I deleted the dir reloaded and could connect, logged off, a few minutes later I tried to login again same error is now back again???? It seems one connection per reload is all that SQLEXPRESS can manage. give me UNIX and Oracle any day for any application. What is worse MS error messages more or less say “you had an error”, well get away, believe it or not I managed to figure that out for myself by the fact it didn’t work, I wish MS coders would put what the error was, doing what, using what, in the error message, might have a chance of sussing it out then.

  6. Thanks! This worked perfectly!

    Note: You may have to change the folder options so that you can see “hidden” files. I could not find my “Local Settings” folder until I changed the folder options. Also, I didn’t delete the directory. I just renamed the SQLEXPRESS file to SQLEXPRESS1 and the fix still worked.

    Thanks again! You’re awesome!

    Cemgates101

  7. Hello;

    I am on a Win2003 computer; I have same error – other posts indices this as solution howver the folder “c:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS ” is not on the computer.

    any suggestions?
    thanks much

  8. Thanks for the hack . The solution works as mentioned .I had this problem getting a default Database from LinqPad to work when connecting to Sqlexpress . Deleting the SqlExpress folder and restarting the service worked for me . Thanks again.

  9. Pingback: SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video « SQL Server Journey with SQL Authority

  10. I encountered this after my ASP.NET dev application “crashed” because I deleted my session cookie but not the forms authorization cookie (I’m using the SQL Session provider).

    All I could find were “that feature isn’t supported on SQL Express” answers to this error message until stumbling here.

    Thank you, thank you, thank you, thank you, thank you!

  11. I started getting this error this morning in a test deployment environment. I was using SQL Server Express 2008 and the error I was getting was

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

    Unsure about what caused it, I followed the instructions in this post and in other post about deleting the “C:\Users\UserName\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS” directory, but to no avail.

    What did the trick for me was to change the connection string from

    “Data Source=.\SQLExpress;Initial Catalog=DBFilePath;Integrated Security=SSPI;MultipleActiveResultSets=true”

    to

    “Data Source=.\SQLExpress;Initial Catalog=DBName;Integrated Security=SSPI;MultipleActiveResultSets=true”

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