I simply want to expose a number of utility SP's from SQL Server 2000 as web services and consume them in a quick-and-dirty WinForms app. SQL Server 2000 is at SP3. Workstation is also the DB server (for now) and IIS host and is XP Pro SP1.
I've followed the SQLXML SP3 BOL verbatim and can see the wsdl files when I attempt to add the web reference. However, when I click on the "soap" service, I get the uninformative message:
There was an error downloading 'http://localhost/nwind2/soap.wsdl'.
The request failed with HTTP status 400: 100 Bad Request.
Having scoured the BOL, MS newsgroups and knowledgebase, I'm stumped. Needless to say, I'm not an IIS expert, neither have I 'consumed' a Web Service before...!
ANY assistance will be appreciated... Thanks in advance.