I just went through the same problem going from version 4 to version 4. (That's not a typo.) There was an obscure dropdown called "SQL Compatibility Mode" and I had to select "40" for it to work.