I have encountered non-technical managers who were good, but in every case they would have been better still had they had some technical background.
I have encountered technical managers who were not good, for various reasons.
I think having a technical background is always a benefit, HOWEVER, it is neither necessary nor sufficient for being a good manager.