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.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure Composite Application

Learn more

Start manage and monitor your Azure Services in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure Composite Application

Learn more

Start manage and monitor your Azure Services in minutes

Back to Top