Reporting Services - Solving a 401 Error

Question

Post reply

Reporting Services - Solving a 401 Error

Patrick_LeBlanc

Ten Centuries

Points: 1160
More actions
October 8, 2009 at 12:23 am

#216141

Comments posted to this topic are about the item Reporting Services - Solving a 401 Error

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Kiran gazzy SSC Eights! Points: 943 More actions · Answer 1

Hi,

Can I use similar procedure for SQL server 2005 SSRS?

Regards,

Kiran

Kiran Gajendragadkar

Tech Mahindra bangalore

Patrick_LeBlanc Ten Centuries Points: 1160 More actions · Answer 2

This only applies to SSRS 2008. SSRS 2005 uses IIS, therefore these options would be set there. shoot me an email at pleblanc@tsqlscripts.com if you need help.

Gary Jobe SSC Rookie Points: 32 More actions · Answer 3

You mentioned at the bottom of this article that you had some other problems with .net applications and the SSRS web service. I have just upgraded to 2008 and we are having some problems with rendering a report from a .net application. We have found that the wsdl reference is different and the methods are also different. We now have it working from within VisualStudio. But, when we try to run the application under IIS we get the following error Message : Client found response content type of '', but expected 'text/xml'. Any ideas?

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 4

This is a very good upgrade article but why it was named "Solving a 401 error" ?

Regards,Yelena Varsha

Patrick_LeBlanc Ten Centuries Points: 1160 More actions · Answer 5

ERROR: Client found response content type of '', but expected 'text/xml'.

We did encounter this error. You have to ensure that your proxy or application is referencing the correct webservice. We refreshed the Web service and the error was resolved. Hope this helps.

Patrick_LeBlanc Ten Centuries Points: 1160 More actions · Answer 6

Thanks. It was named that way because if you do not follow all the steps you will encounter a 401. We maybe should have added something about upgrading in the title. Thanks for the comment.

stowe SSC Rookie Points: 37 More actions · Answer 7

Hi there,

For a long time I struggled with 401 type Auth errors with my SRS 2005 installation. After many unsuccessful approaches I found the issue in my case was caused a slipstream server installation on Windows Server 2003 with SP2.

With this type of installation the default authentication providers for IIS websites were turned off.

To fix this I had to manually enter the provider in the Metabase.xml file located in the \system32\inetsrv folder.

Here is an example of what I had to do to fix the problem....

<IIsWebVirtualDirLocation ="/LM/W3SVC/1/ROOT/ReportServer"

AccessFlags="AccessRead"

AppFriendlyName="Report Server"

AppIsolated="2"

AppRoot="/LM/W3SVC/1/Root/ReportServer"

AspAllowSessionState="TRUE"

AspBufferingOn="TRUE"

AspEnableParentPaths="FALSE"

AspScriptLanguage="VBScript"

AuthFlags="AuthNTLM"

NTAuthenticationProviders="NTLM"

Path="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer"

ScriptMaps="*,C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll,1"

The only piece I had to add was this line: NTAuthenticationProviders="NTLM"

One additional note: To make this change you must first go into Internet serverices mananger Right click at the highest level (server Icon) in the console and choose properties.

Place a check in the box to enable direct metabase edit.

After completeing the process I did an IISreset and voila....weeks of struggling fixed by one little entry.