Complete Error Message: “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 found a solution at: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f5eb164d-9774-4864-ae05-cac99740949b/
Check comment by “Scott J Baldwin - Posted on Thursday, March 30, 2006 8:28:58 PM”.
Main points from his reply:
- Delete C:\Documents and Settings\USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS.
Remember to replace USERNAME with your username.
- Also check if the SQL service account has the necessary permissions.
- It is possible to attach to databases in the traditional by edit the connection string and delete the "user Instance=true". User Instances just make it easier (when it does work) to work with databases as though they were files.
Thanks Scott J Baldwin.