This is to record this stupid mistake for accessing WCF service in SSRS report as datasource/dataset.

I implemented the WCF service and had the address like http:localhost/WCFDataService.svc.

I accessed the service in my browser, no problem, I saw the example page and I was able to access the wsdl.

I setup the datasource in SSRS report project, placed “http:localhost/WCFDataService.svc” in the connection string: text box.

I got remote server 404 not found error.

And then I thought hmm, maybe something wrong with the address.

I tried to use SOAPUI to access the service endpoint without issue.

And then I tried Java client without issue.

And then I was like, ok, let me try WCF client, without issue!

I could not figure out what went wrong and I was stucked for a day and doing other things tried to clear my mind.

I came back in the evening and start working on it.

I tried many clients again, none of them has issue except SSRS datasource/dataset.

I then carefully looked at each configuration of each client.

I found in the WCF client service reference, the connection string was “http://localhost/WCFDataService.svc/WCFDataService “.

……. oh well, lesson learn, and I am recording this in case I forgot in the future.

hope this help if you had the same issue.