Linked Servers and CUIC

Like several other posts here, we are having an issue with ANSI_WARNINGS and ANSI_NULLS when trying to create a report definition against a linked server in CUIC 10.x.

I understand from previous posts, that we need to have these set on the connection, but to do that, I need to change the server option on the AWDB and the external server.  Is this correct and is it supported?

If I understand, you can set these option in your SQL.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

That is not working.  It still says we have to set it in connection properties, which we can do, but just wondering if it is supported to change a server-wide setting

- Paige Delk

Sent from my iPhone

(please excuse typos)

You are correct, its in the connection properties.