I deployed an ASP.NET MVC app using MSDeploy and ran into this problem i tried every solution that i found over internet and i still can't get this working it's a small basic MVC 2 app that I built while learning. so..
Screenshot
http://screencast.com/t/0tBZoHoN
Can you take a look at this question?
https://serverfault.com/questions/1886/failed-to-generate-a-user-instance-of-sql-server
Maybe it can help you.