The sad story brought me to tears.

Literal

Sad story [to-に] tears [object-を] was-moved-to.

涙を催した means 'was moved to tears' — 催す means 'to feel prompted to.' An i-adjective (悲しい) directly modifies the noun 物語.