Issue using in-memory SQL Express database with in Visual Studio

|  Posted: January 18, 2010  |  Categories: General Technical

This post is for my own reference, just to avoid this in the future. It happened to  my twice already.

I was trying to add a new in-memory databse (Add New Item ? SQL Server Database) within visual studio to quickly knock some prototype and was constantly greeted with this error message.

“Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance”

After a bit of digging and binging, the solution is to delete the SQL express folder completely founder under the user directory

C:Documents and Settings<<your login>>Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS

Then, you may be greeted with Timeout error, but try again. It will be ok second time.

Nandri

Saravana

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments.

Back to Top