Showing posts with label response. Show all posts
Showing posts with label response. Show all posts

Sunday, February 26, 2012

error trying to start new maintenenace plan

Hi ,
I am new to sql 2005 and clustering I too have made the same mistake as
wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I
have installed SQL within the cluster. I just need clafication that I only
need to run the setup and just select integration services no other options
and It will install fine. Do I need to install this on the second node?
Regards
Steve
Try this
How to: Configure Integration Services on a Cluster
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"steve" <smithsls8@.hotmail.com> wrote in message
news:e2Z2dOTWHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Hi ,
> I am new to sql 2005 and clustering I too have made the same mistake as
> wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I
> have installed SQL within the cluster. I just need clafication that I
> only need to run the setup and just select integration services no other
> options and It will install fine. Do I need to install this on the second
> node?
> Regards
> Steve
>
>

Sunday, February 19, 2012

Error System.InvalidOperationException: Client found response cont

Hi, All.
I have a windows 2000 server machine with SQL Enterprise 2000 edition and
reporting service enterprise edition on it.
The Report Mangaer application and the Report Server Web service are both
working.
and i have a web application that makes calls against the reporting service
API.
and I get the following error regardless of any method I call.
System.InvalidOperationException: Client found response content type of
'text/html', but expected 'text/xml'. The request failed with the error
message: -- -2146893039 (0x80090311) --. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
Recursive).
Can anyone help to explain what to do?
tksThe problem is you are getting back an html response rather then a SOAP
response (xml). Have you verified that the .Url property is correct set on
your proxy object?
The error you are seeing is:
No authority could be contacted for authentication.
Have you set the credentials property correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hang" <Hang@.discussions.microsoft.com> wrote in message
news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> Hi, All.
> I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> reporting service enterprise edition on it.
> The Report Mangaer application and the Report Server Web service are both
> working.
> and i have a web application that makes calls against the reporting
> service
> API.
> and I get the following error regardless of any method I call.
> System.InvalidOperationException: Client found response content type of
> 'text/html', but expected 'text/xml'. The request failed with the error
> message: -- -2146893039 (0x80090311) --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> Recursive).
>
> Can anyone help to explain what to do?
> tks
>|||Thanks for replying, Daniel
Yes. the .Url property is correct. I explicitly set it once i create a proxy
object.
here is a sample code
Dim rs As sqlReport.ReportingService
rs = New ReportingService
rs.Url = "http://severName/ReportServer/ReportService.asmx"
rs.Credentials = New NetworkCredential
("userName", "password", "theDomainName")
Dim c As CatalogItem() = rs.ListChildren("/", True)
that is the code code that throws the exception
by the way, On the same server, I used to have reporting service evaluation
edition and my application worked fine.
Then I got that problem after installing the official version(I uninstalled
the evalutiaon edition and deleted all the database associated with it before
installing).
tks.
"Daniel Reib [MSFT]" wrote:
> The problem is you are getting back an html response rather then a SOAP
> response (xml). Have you verified that the .Url property is correct set on
> your proxy object?
> The error you are seeing is:
> No authority could be contacted for authentication.
> Have you set the credentials property correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Hang" <Hang@.discussions.microsoft.com> wrote in message
> news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > Hi, All.
> > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > reporting service enterprise edition on it.
> >
> > The Report Mangaer application and the Report Server Web service are both
> > working.
> > and i have a web application that makes calls against the reporting
> > service
> > API.
> > and I get the following error regardless of any method I call.
> >
> > System.InvalidOperationException: Client found response content type of
> > 'text/html', but expected 'text/xml'. The request failed with the error
> > message: -- -2146893039 (0x80090311) --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > Recursive).
> >
> >
> > Can anyone help to explain what to do?
> >
> > tks
> >
>
>|||Just to follow up on this. It turned out it was an credential problem in this
case.
The web server, which hosts the web application, needs to be in the same
domain as that of the web server hosting the reporting services web service.
And a proper domain account is needed for accessing the reporting services
web service in this case.
hope this helps others who have encountered similiar problems.
Tks
"Hang" wrote:
> Thanks for replying, Daniel
> Yes. the .Url property is correct. I explicitly set it once i create a proxy
> object.
> here is a sample code
> Dim rs As sqlReport.ReportingService
> rs = New ReportingService
> rs.Url = "http://severName/ReportServer/ReportService.asmx"
> rs.Credentials = New NetworkCredential
> ("userName", "password", "theDomainName")
> Dim c As CatalogItem() = rs.ListChildren("/", True)
> that is the code code that throws the exception
> by the way, On the same server, I used to have reporting service evaluation
> edition and my application worked fine.
> Then I got that problem after installing the official version(I uninstalled
> the evalutiaon edition and deleted all the database associated with it before
> installing).
>
> tks.
> "Daniel Reib [MSFT]" wrote:
> > The problem is you are getting back an html response rather then a SOAP
> > response (xml). Have you verified that the .Url property is correct set on
> > your proxy object?
> >
> > The error you are seeing is:
> >
> > No authority could be contacted for authentication.
> >
> > Have you set the credentials property correctly?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Hang" <Hang@.discussions.microsoft.com> wrote in message
> > news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > > Hi, All.
> > > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > > reporting service enterprise edition on it.
> > >
> > > The Report Mangaer application and the Report Server Web service are both
> > > working.
> > > and i have a web application that makes calls against the reporting
> > > service
> > > API.
> > > and I get the following error regardless of any method I call.
> > >
> > > System.InvalidOperationException: Client found response content type of
> > > 'text/html', but expected 'text/xml'. The request failed with the error
> > > message: -- -2146893039 (0x80090311) --. at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters) at
> > > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > > Recursive).
> > >
> > >
> > > Can anyone help to explain what to do?
> > >
> > > tks
> > >
> >
> >
> >