Just a day ago, I was installing SQL Server Express on the backup computer. I only use this computer when I have something to experiment with. 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 trial and error I found the solution for Error 15372.
Let us see how we can fix the error which is related to error 15372.
Error: 15372, Severity: 16, State: 1.
Failed to generate a user instance SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
The solution for this error is fairly simple.
Delete the directory “c:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS “
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. I did my best to explain how to solve this error in less than sixty seconds.
Let me know if you know any other way to solve this problem. I will be happy to learn how to solve this error if there are any other way to solve it.
Reference: Pinal Dave (http://blog.sqlauthority.com)