While running the upgrade script on the database I am getting the following error:
Msg 3701, Level 11, State 5, Line 70Cannot drop the view 'View_custom_SurvivorStory_Joined', because it does not exist or you do not have permission.
I have validated that the user is db_owner and the view 'db_owner.View_custom_SurvivorStory_Joined' exists. Any thoughts on the matter would be helpful.
Is db_owner the equivalent of dbo? if not - this could be an issue.
If this is the only issue I'd say go ahead and manually drop it.
I'd say connect to your DB server using the same credentials your installation uses to see what you may (or may not do). Easier to test/debug any changes.
Please, sign in to be able to submit a new answer.