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