Can connect from Query Analyzer but not from Report Services

I can terminal service into the box running Reporting Services. If I try to
run the
report I can't connect, it says login failed. Using the same
username/password which is sa because it's a log shipped server. I can
connect through Query Analizer. The only rememdy is to restart both servers.
Then I can connect. Then it will go hey wire after a day or two and same
situation. What could be causing this?
Please help me,
BryanAlso if I try to do net stop reportserver it says the server is not
responding to the control function. Actually the same thing happens if I try
to shut down the secondary log shipped server that the reports are pointing
at. If I do net stop mssqlserver. It gives me the same error. Something is
going on here between the two and I can't figure out what it is that is going
on?
"bmurtha" wrote:
> I can terminal service into the box running Reporting Services. If I try to
> run the
> report I can't connect, it says login failed. Using the same
> username/password which is sa because it's a log shipped server. I can
> connect through Query Analizer. The only rememdy is to restart both servers.
> Then I can connect. Then it will go hey wire after a day or two and same
> situation. What could be causing this?
> Please help me,
> Bryan