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

Published on : Jan 18, 2010

Category : General



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