13 February 2009

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.



Post a Comment

Note: Only a member of this blog may post a comment.