Brian H. Madsen - .Net Powered by Caffeine : SQL Server 2008 Reporting Services

SSRS 2008 Add-in for MOSS 2007, Report Viewer 401: unauthorised error

Brian Madsen — Tue, 16 Jun 2009 00:14:38 GMT

Battling with network issues can be a PITA – battling with network issues AND application errors is a FPITA!

A problem popped up the other day with the Report Viewer, while selecting a report to display in the SQL Server 2008 Report Viewer web part.

We could run the Report Viewer web part on the server itself, but from anywhere else on the network it just didn’t work and it kept throwing this error:

Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.

Rather annoying so we thought the proxy was causing the problem..but, nopes, doesn’t seem like that was the issue as we were told that the internal servers, if addressed via fully qualified domain names, didn’t get proxied.

ok…what else to do? some suggested Alternative Access Mappings were wrong…tried to add what was “missing” there..still a no go.

It was obvious that something was dropping off the authentication request somewhere as we were running in “Windows Authentication” mode, using NTLM.

fix was…

Go to the SharePoint 3.0 Central Administration –> Application Management –> Reporting Services –> Manage Integration Settings and change the Authentication Mode to “Trusted Account”..

Now, of course, i need to find out why Windows Authentication mode isn’t working…at least we can proceed now.

David Lean shows us how to use conditional formatting in SQL Reporting

Brian Madsen — Tue, 17 Feb 2009 10:43:03 GMT

wow i say!!

David Lean has just released an in depth, 4 part series on how to use conditional formatting in SQL Reporting.

This is probably the best and most in depth blog post i’ve seen on this topic!

seriously worth the read if you’re working with SSRS and wants to impress some narky execs with some flair in your reports!

After having had a good read through those 4 long posts i’ve come to the conclusion that SQL Reporting is far more adaptable and flexible than i’d previously given it credit for.

Enjoy the technical read!!

SQL Server 2008 Reporting Services Add-In for MOSS 2007 installation failure..

Brian Madsen — Wed, 03 Sep 2008 08:25:00 GMT

I'm trying to get SQL Server 2008 Reporting Services Add-in for MOSS 2007 working and have everything set up, from the SQL Server side of things, to get this running.

But, while i'm trying to run the installer i'm told that the installation has been interrupted - so the installer doesn't seem to be working.

I looked at the logs on the SQL Server to see what was happening and for some reason it's trying to connect to the server as NT Authority/Anonymous - which isn't working. That was the first step and "thought" i'd located a fix for that.

What i tried was to run the following command, which only installs the files:

rsSharePoint.msi SKIPCA=1

and then move to the "Temp" folder and run:

rsCustomAction.exe /i

that threw a different error:

User: xxxxxxx
Installing Report Server feature.
Calling copyappbincontents command.

Access denied.

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensi
ons\12\bin\stsadm.exe return error code: -2147024891
Error details: System.Exception: C:\Program Files\Common Files\Microsoft Shared\
Web Server Extensions\12\bin\stsadm.exe return error code: -2147024891
   at RSCustomAction.BaseProcessLaunch.LaunchCommand(String fileName, String arg
uments, Boolean ignoreExitCode)
   at RSCustomAction.StsadmCommands.CopyAppBinContents()
   at RSCustomAction.RSFeatureSetup.Install(Boolean repair, Int32 addRetries)
Uninstalling Report Server feature.
Uninstalling Report Server feature.
Report Server feature was uninstalled.
Stopping W3SVC service.
SSRSCustomActionError: Cannot open W3SVC service on computer '.'.

Has anybody had this error before? my account is part of the local administrators group on the server and searching for that error code seems to reveal nothing either.

Any ideas?