SQL Express Error – “Failed to generate a user instance of SQL Server”

Having lots of fun with SQL Express tonight, attempting to load another sample I hit another error:

—————————
Microsoft Visual Studio
—————————
Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.
—————————
OK  
—————————

In the connection string, I changed it from creating a user instance each time to using a single instance and it appeared to solve my problem.

This is done by modifying the connection string to be “User Instance=False;” instead of “User Instance=True;”

Technorati Tags:

One thought on “SQL Express Error – “Failed to generate a user instance of SQL Server””

Leave a Reply to swati Cancel reply

Your email address will not be published. Required fields are marked *