A connection must have the ANSI_NULLS and ANSI_WARNINGS options turned on before it can execute distributed queries.
SET ANSI_DEFAULTS