I used Visual Web developer 2008 to create a web site that uses the built-in ASP.NET Membership functionality to create users and roles. Works perfect on my my computer, but when moved to the web site (my VPS), I get the following error:
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.