The stochastic reflection problem in Hilbert spaces