I created an HTTP Endpoint on SQL Server 2005 database to retrieve all users from a table within a database. I can preview the wsdl document in IE on the server and remote servers no problem.
After I add the WebMethod, I get no results returned from the database, however, if I use a print statement within the stored procedure, previewing the InfoPath form returns the print statement (ex. Print 'HELLO WORLD'.