Hi
I am trying to use the connection string for SSRS.
I can add the connection string, and if I browse to the URL internally then it returns me some nice XML detailing all the reports
i.e. http://web-a.farplants.sbs/ReportSer...ution2005.asmx
etc
however when I choose New > Link SQL Server Reporting Services Report
choose my connection string I get the error message
Looks like the request isnt getting through, although a wireshark trace shows alpha is talking to the server and getting a HTML/XML response
SSRS 2008
Alpha V12.4.4.5, Build 4491
Have tried with Windows and basic authentication
Internal and local URL to IIS, with and without local domain.
I am trying to use the connection string for SSRS.
I can add the connection string, and if I browse to the URL internally then it returns me some nice XML detailing all the reports
i.e. http://web-a.farplants.sbs/ReportSer...ution2005.asmx
Code:
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" targetNamespace="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"> <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"> The Reporting Services Execution Service enables report execution </wsdl:documentation> <wsdl:types> <s:schema elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"> <s:element name="ListSecureMethods"> <s:complexType/> </s:element> <s:element name="ListSecureMethodsResponse"> <s:complexType>
however when I choose New > Link SQL Server Reporting Services Report
choose my connection string I get the error message
Code:
Could not get list of reports. Error reported was: Unexpected exception Native error code: -1 Native error text: Client found response content of type '', but expected 'text/xml' The request failed with an empty response
SSRS 2008
Alpha V12.4.4.5, Build 4491
Have tried with Windows and basic authentication
Internal and local URL to IIS, with and without local domain.
Comment