View Single Post
 
Old February 18th, 2009, 07:59 PM
AspNew AspNew is offline
Authorized User
 
Join Date: Dec 2008
Posts: 29
Thanks: 1
Thanked 5 Times in 5 Posts
Default

Ok, folks, after digging into the error in details and googled msdn's website for the "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.
" error, I came up with the following discussion:

http://social.msdn.microsoft.com/For...-cac99740949b/

and fixed my problem with Mike Wachal of the SQL Express Team's suggestion, I removed the SQLExpress folder my C:\Documents and Settings\<user name>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data folder, and viola, it works.

I spent over few days on this problem on such a obscure fix, couldn't Microsoft comes up with a more meaningful error message?

P.S. The problem seemed to be the result of the upgrade from SQL Server 2005 to 2008.