SA Developer .NET

Hi
 
I have two front end servers in my farm. Reporting services is installed (in integration mode) on both servers (both using the same database).

Everything was working fine until Friday... now I’m getting the following error, but only on one of my front end servers.

This is being reported from the web parts that used to show the reports.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
The request failed with HTTP status 404: Not Found.

Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane.
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
The request failed with HTTP status 404: Not Found.

If i try to connect to the "managed shared schedules" under site settings i get

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

The weird thing is that if i use the other front end server, everything works fine.

I've tried re-installing reporting services and the add-in for SharePoint. nothing :(

The log files (SharePoint and reporting services) don't have anything useful in them.

All servers can ping each other, using their IP addresses and names (with DNS suffix and with out it)

I'm tearing my hair out here.... Any help would be appreciated!

 

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

Don't know if this will help, I don't have much experience with Reporting Services, but we're having a similar problem right now as well in our DEV environments. The one server connects to the database fine, and the other one can't... We think it has something to do with a patch that might have been installed on the one server and not the other one, but the one way to check is to open the Report Server Configuration on the server that's not working, select database setup and click "Upgrade"... See what it says, our's moans that it's got a different version of something, and it can't be upgraded, so we're stuck, but it might work for you...

---

"I would love to change the world, but they won't give me the source code"
Meeting Place - chat online with anyone, anytime, no downloads or plugins required

Ahh, a glimmer of hope. thanks.... but

[tick] Verifying Database Edition - The taks completed successfully.

[tick] Verifying Database Version

damn.

good idea about patches: i'm going to compare all the patches that have been installed on each box now and see if any were instaled when everything went pear shaped [/me keeps fingers crossed]

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

mmmm, patches are usually a good thing, however they should never go to production before going to QA,

Did you check running services, service accounts, kerberos?! Possible infrastructure issues around servers and domain, dns etc?!

Let me know how it plays out.

patches between the boxes are the same

>>they should never go to production before going to QA,

agreed!, please tell our infrastructre team in london that ;) once a patch is "bank approved" it gets rolled out retro spectively. :(

services are all running (with the same domain accounts). none of the accounts are locked out. (in despertion i've made them ALL local admins on all the boxes - but no luck)

we aren't using kerberos - it's been setup using "trusted account" mode.

*sigh*

according to our infrastructre team, the only chnage that was made on the weekend was the addidion of a new domain suffix in the IP configuration. i've rolled back that chnage, but it fixed nothing.

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

do you know of a way that i can find out what URL it's trying to access?

i just get this error : An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. 

and i can't find anything in the log files.

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

This might be a silly question, but can you browse to the report via the web front end. As in http://localhost/reportserver or http://localhost/reports and run it. Running it in that enviroment will give you more detailed errors.

 

---

If you can't explain something to a six-year-old child, you really don't understand it yourself. - Albert Einstein

DoubleJ: 

Well, for that go to Reporting Services Configuration Manager under Configuration Tools. 

Also check in Application Management in (SharePoint) Central Administration whether everything is correctly configured in the Reporting Services section (server, authentication etc).

 DionB:

When you install Reporting Services in SharePoint integrated mode (as far as I know) you can't do that no more.

the odd thing is that i can browse to the http://sjnbfrkiis03/reportserver from both the Front End servers.

when i browse there i get a pseudo-directory listing that shows me my shrepoint sites.

Becuase RS is in integration mode, there is no http://localhost/reports URL to access - it doesn't get installed. infact if you upgrade a naitive rs to integrated RS, the installtion process recommends that you remove the /reports application.

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

Zlatan:

Well, for that go to Reporting Services Configuration Manager under Configuration Tools. 

Also check in Application Management in (SharePoint) Central Administration whether everything is correctly configured in the Reporting Services section (server, authentication etc).

got green ticks across the board in RS Config manager (with the exception of the blue exlamation next to encryption keys, as it wants me to constantly back them up)

in app management in central admin, i've setup the URL and set the authentication to "Trusted", i've given all the service accounts access to the RS databases.

The "set server defaults" opens and these are the settings

[tick] Do not limit the number of snapshots

Limit report processing (in seconds): 1800

[tick] Enable report processing log

[tick] Remove log entries older than this many days - 60

[tick] Enable Windows integrated security for report data sources

[tick] Enable ad hoc report executions

 

i'm totally clueless as to whats gone wrong. i'm ready to rebuild the server now

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

Please let us know if you find the answer. It will be very helpful in future.

---

If you can't explain something to a six-year-old child, you really don't understand it yourself. - Albert Einstein

Well, this resolves a 3 week investigation.

It turns out that there were a few things that caused this. To answer the question "why did it break", i have no idea. all i can say is that this resolved the problem.

1) in the web.config file for all the WFE's i removed the proxy. (it seems that proxy thought that the other servers were not local). so i changed

    <defaultProxy>
      <proxy usesystemdefault="false" proxyaddress="http://proxy:8080" bypassonlocal="true" />
    </defaultProxy>

 to

    <defaultProxy>
      <proxy usesystemdefault="true"  />
    </defaultProxy>

2)   this then caused the error to change from 404 Not Found to HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.

to fix this, i rant the following command in c:\intepud\adminscripts\ on all the WFE's

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ

It's worth mentioning that while the above sorted out the main probelms, RS now seems to have decided that it's holiday wasn't long enough and is working at 50% of its original speed.

I'm also getting intermittant errors like

• The request failed with HTTP status 400: Bad Request. 

• Execution 'vxo540rnf5n1gciacynq2l45' cannot be found (rsExecutionNotFound) 

---

You cannot make anything fool-proof... Fools are too inventive

http://dotnet.org.za/doubleJ