ok, i had the same issue, as did almost nobody else. much hair loss later, i discovered it was my sql server user – was being prompted for a password change!! logged in via sql mgmt studio as that user, changed the password and the script ran all good.
