Contrary to what Benta wrote, this should work.
The Ideal excitation for a 2-phase bipolar stepper motor are two sine waves with a 90 degree phase difference between them. This means you should use the biggest capacitor you can find to approximate this 90 degree phase difference. I'm thinking about a bipolar electrolytic of a few thousand uF. You can also put two "regular" electrolytic capacitors back to back to prevent AC leakage, but I don't know how long that will hold.
As you don't have a real controller in this case, you will have to limit the voltage to the motor to prevent overcurrent and over heating.
Most common are the 200 steps/revolution motors, which would result in 1 revolution per second with a 50Hz input signal.
I wonder why it does not work for you. Do you have a schematic? What sort of capacitors did you use? Which youtube video's did you see?