I say.

A blog by Joakim Beijar, I solve interesting and mundane problems at Mios Ltd and hack at night on github.com/kaa.

On Sql Server 2008 Express in User Instance mode

15 Aug 2008

When faced with

Failed to generate a user instance of Sql Server due to a failure in starting the process for the user instance

when connecting to Sql Server 2008 Express from Visual Studio, make sure the account running Sql Server has access to the following directory

C:\Users\<UserName>\AppData\Local\Microsoft\Microsoft SQL Server Data