Your hose connection is leaking because of a worn-out hose gasket. You need to take the hose off the faucet or remove the sprinkler. Replace the old or missing gasket with a new one. If the leak is still there, you will need to replace the connector in its entirety.