Is it ever appropriate to ask a professor to be a business advisor?
Due to the mentioned ethical aspects you should avoid any financial relationship with professors of which you are still taking courses. 

On the other hand, it is happening quite often that a professor is supporting a start up and compensation can be either money, company ownership, or sometimes just personal satisfaction.