InfoPath Dev

Created main data connection in InfoPath form using SQL database using SQL credentials.  Connects like a champ when I preview via InfoPath.  However, the published form in Sharepoint will not connect.  Doesn't even hit the SQL server and gives me a 6932 cross-domain error.  Not crossing any domains, all the same.  I understand the 2-hop theory since SP is on one server and SQL on another.  My SP server has Forms Services cross domain enabled.  Where do I set the zone InfoPath form loads - on the SP server or my local machine?  Thanks! Julie

Just letting everyone know I've resolved this issue and my data connection works like a champ!  Thank goodness I was able to figure this out on my own.

How did you resolve it?  Through a UDC file and SSO or just UDC?  I'm sorry that I didn't see this when you first posted, else I would have answered.  Cross-domain doesn't mean different AD domains - just the 2-hop aspect you were talking about.