Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting Services - Solving a 401 Error


Reporting Services - Solving a 401 Error

Author
Message
Patrick_LeBlanc
Patrick_LeBlanc
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 324
Comments posted to this topic are about the item Reporting Services - Solving a 401 Error



Kiran gazzy
Kiran gazzy
SSC Eights!
SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)SSC Eights! (829 reputation)

Group: General Forum Members
Points: 829 Visits: 130
Hi,

Can I use similar procedure for SQL server 2005 SSRS?

Regards,
Kiran

Kiran Gajendragadkar

Tech Mahindra bangalore
Patrick_LeBlanc
Patrick_LeBlanc
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 324
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
Gary Jobe
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 170
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
Yelena Varshal
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3480 Visits: 593
This is a very good upgrade article but why it was named "Solving a 401 error" ?


Regards,
Yelena Varshal

Patrick_LeBlanc
Patrick_LeBlanc
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 324
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
Patrick_LeBlanc
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 324
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
stowe
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 9
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....
<IIsWebVirtualDir Location ="/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"
DirBrowseFlags="DirBrowseShowDate | DirBrowseShowTime | DirBrowseShowSize | DirBrowseShowExtension | DirBrowseShowLongDate | EnableDefaultDoc"
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search