no search results, accessing SQL Server 2005 endpoint with Web Service Toolkit for Office 2003

[jahu]

Dear all,

I try to reference a web service of a SQL server 2005 by using the
Microsoft Office 2003 Web Services Toolkit 2.01 from within Excel. The
dialog does not list the exposed services of the server and print a
message that the search could not identify any results. Using other
services like http://soap.genome.jp/KEGG.wsdl the toolkit is working
fine. If I use Visual Studio 2005 and C#, I can access the service
made available by the SQL Server 2005.

The stored procedure exposed by the endpoint is very basic and returns
only a string, so I can not imagine an problem there. The granted user
permissions are working because I can invoke the service with C#.

I appreciate your comments very very much!

With kind regards
Jan Hummel

 

[jahu]

I want to add, that I tried this different wsdl versions
http://2003dellp285002/gmd?wsdl , http://2003dellp285002/gmd?wsdlsimple
and http://2003dellp285002/gmd?wsdlcomplex, all with the same result.
The Listbox with all available services is empty. If I download the
wsdl file first, and try to apply the web service toolkit on this
saved file I get the same empty list of available services.
Your comment is very apreciated!

With kind regards
Jan Hummel