Will the vaccine make me sick with COVID-19?

No, the vaccine will not make you sick with COVID-19.  It stops you getting sick from COVID-19.