Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Does not work with SQL Server 2016 #5

Open
EliJDonahue opened this issue Jan 26, 2018 · 4 comments
Open

Does not work with SQL Server 2016 #5

EliJDonahue opened this issue Jan 26, 2018 · 4 comments

Comments

@EliJDonahue
Copy link
Contributor

The HttpWebRequest returns the HTML for the Reporting Services Web Portal, not the report content, when using the sample code with SQL Server 2016.

I found the same issue reported in a MSDN forum. Based on the forum post, this sounds like an issue specific to SQL Server 2016. SQL Server 2014 is probably fine, though I have not tested it myself.

@AngelaIp
Copy link
Owner

Although I do not know the 2016 version, maybe this is relevant:
Which URL path do you use to access the Report Server?

Do you use http://myreportserver/Reports/ or http://myreportserver/SSRS/?

If you test both links in the browser, you will get a GUI when using the ../Reports path.
The path ../SSRS shows only a simplified interface without graphic elements.
In my case, only the ../SSRS path worked.

@EliJDonahue
Copy link
Contributor Author

I tried using http://localhost/SSRS/ in both my method code and in my browser but I got a 404 error both times. It's possible that my server is configured differently or the /SSRS url support was removed sometime between SQL Server 2012 and 2016.

@AngelaIp
Copy link
Owner

AngelaIp commented Feb 1, 2018

Using the ../Report path created a 401 error in my case.
But I also have seen the 404 error (and many 50x).

In my case the Variable ‘Report Server Folder’ was missing. The Variable should have the same name as the folder on the Report Server.

@AngelaIp
Copy link
Owner

AngelaIp commented Feb 5, 2018

Today I have seen a similar effect while creating a regular Report Service launched from an Item.
When using Firefox, I only got the RSGateway.aspx as download result, but not the report content. I am quite sure, that this was different in the past. Chrome and IE gave me the direct (Excel)-file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants