I did something really weird.
Not even sure how much it is related to sitefinity.
I was writing some code and cause my application to crash, probably wrote some strange data into my database. My app was using its own local file as the database. (sitefinity.mdf)
When the application crashed i started getting some strange errors 505. I could not get the app to start again so i played with iis a little.
At this point i started to get the "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path." error.
I assumed that i somehow corrupted the db. So i found my backup copy of the application and tried that one.
Still the same error. Now that is strange since earlier that day it worked fine.
At this point i started getting suspicious and tried a different application. One that happened to be using a database i created within my sql server instance. That app worked fine. No problem at all.
At this point i unzipped a blank project and tried to create a new app again using the sitefinity.mdf file. Can't do it. Get the error again.
Don’t know what’s going on here, can’t run any app that uses the sitefinity.mdf file but can run one that has an sql database.
Anyone else seen this problem before?