Error: Failed to generate a user instance...

Hello,

When trying to add a new SQL database to a VS 2005 project I get this error:

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. [CLIENT: <local machine>]

Any ideas what is causing this error and how to fix it?

Thanks

Tom

Hi Tom,

This question has been discussed several times in this forum, you should do a search and read other discussions to see if they address your issue.

The first step in troubleshooting this is to look at the User Instance error log located at C:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\<main instance name> (The default instance name is SQLEXPRESS) and see if it give any clues to the cause of the error.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.