%META:TOPICPARENT{name="ErrorMessagesH"}%

= Error Message: {{{Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection}}} =

Resolving this error requires some settings be adjusted on the SQL Server itself.

# Open your **Microsoft SQL Server Enterprise Manager.**
# Drill down to **Console Root** --> **Microsoft SQL Servers** --> **SQL Server Group**
# Right-click the icon for your SQL Server instance.
# Select the **Properties** menu item.
# Click the **Connections** tab.
# Tick the boxes for **ANSI warning** and **ANSI nulls.**
# Click **OK.**
# Exit the Enterprise Manager.
# Test.


==Evidence==

* Request Broker Log