That’s happened to me as well.
I’ve debugged all day and haven’t found anything. The activation functions are run,the database is populated, the options table is updated (active_plugins) but then… nothing. It just goes back to being unactivated. Must be some weird bug with WordPress itself.
My solution was to manually add the plugin to the active_plugins options in the database. :/