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.

1. Open your Microsoft SQL Server Enterprise Manager.
   
2. Drill down to Console Root --> Microsoft SQL Servers --> SQL Server Group
   
3. Right-click the icon for your SQL Server instance.
   
4. Select the Properties menu item.
   
5. Click the Connections tab.
   
6. Tick the boxes for ANSI warning and ANSI nulls.
   
7. Click OK.
   
8. Exit the Enterprise Manager.
   
9. Test.

Evidence

• Request Broker Log