.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server


I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

    View Complete Post

More Related Resource Links

How to upload a URL link into Report Server using Report Manager?

Hi I would like to have a URL link in Report Server that directs to one of our directory folder that has a history of pdf reports. I want to know if its possible to do this by just having to upload the URL link into Report Server, like we upload the .rdl files using Report manager. Is there any way to do this? Please let me know. Thanks

Unable to upload report file to SSRS 2008 R2 Express

I'm attempting to upload a report file into an instance of SQL Server 2008 R2 Reporting Services (Express edition), and I'm having difficulty. While I can do things like create folders and manage security, I am unable to upload a report definition (.rdl) file from either the web console or via the ReportService2005.asmx web service. Both avenues eventually time out and generate a 401 error (though I am not sure that this 401 is legitimate, as it takes over a minute and a half to generate the error).

This instance is running the web services on a non-standard port (8080) in HTTP (not HTTPS) mode, as it's on a Windows XP Pro machine with an existing website on IIS.

I have looked at the report server access log, and this appears to happen when it errors out:

    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: ReadCallback(): failed to read in read callback.
    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: HttpPipelineCallback::ReadEntityBody(): failed reading data.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.

ssrs report link subscription


I am using a data driven subscription. Is there a limit to the number of characters that i can pass as a parameter to the subscription??


This is the link i get in the email. instead of report parameters being passed, I see StoredParametersID being passed which causes it to error out as the parameter required for the snapshot is not being passed.

This link works


SSRS 2008 Custom Authentication works when using ReportServer url but not when report manager url is

Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please!   Thanks!

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Missing Tabs and Site Settings Link in Report Manager


Installed SQL Server 2008 with Reporting Services to a Windows Server 2008 box.  Tried to open the Report Manager and had no tabs and no Site Settings link - just a blank home page. I am logged onto the server with local administrator rights, so it shouldn't be a permissions issue.

Thinking the installation was bad (IIS was not installed before installing SSRS), I uninstalled and re-installed SSRS after setting up IIS 7 on the server.  Still the same issue - just a blank home page in report manager with no ability to add users or assign roles or see anything except the links for "Home", "My Subscriptions", and "Help".

Any suggestions would be appreciated.

Hide Report Builder link in 2008 r2


I would like to hide the link to report builder. I have taken the role away but the link still shows up. I am using a security extension.



Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

Track the visitors in ssrs 2008 report manager


Can any one please let me know How to track the visitors list in the SSRS 2008 report manager and count of number of visitors to that report.

Thanks in advance.

Disable "Include Link" option in Report Subscription


Can the "include link" option be disabled?
So that when users are setting up subscription they do not see it or it is disabled.

Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



SSRS 2008 Report Manager only accessible within the server, cannot open on a different PC


How should I configure my SQL 2008 Reporting Services so that the Report Manager can be accessed outside the server.  That is, from a different machine within the same network?  Whenever I try to access the Report Manager from another machine, a prompt will appear requesting for username/password several times before a blank page is shown.

Reporting Services Configuration Details:
Service Account: Local System
Execution Account: Tried using my own login details within the domain and tried without it

Please let me know if you need any other details.  I am running out of ideas on what I can possibly do, thanks!


stop prompting credentials while opening report manager in SSRS 2008


Hi All,

Can u please help me on how to stop asking the credential while opening report manager/ report server  in SSRS 2008.

I know we can solve this easily in 2005 by setting permission to IIS.  But I don't know how is here?

I searched lot in google but no success.

Kindly help me.

Thanks a lot.

Cannot get subscription email when including report, but can get it when just sending link


When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF."  When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.


I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.


Any suggestions?



How to display related tables in one crystal report and how to link this report with combobox?


Hi! I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Now if I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names. How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box? Help me friends. An example would be appreciable.

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

LINK : fatal error LNK1104: cannot open file 'libirc.lib'

I am trying to build my project for 64 bit windows on a 32 bit windows machine. I am getting a linking error of the kind 15>LINK : fatal error LNK1104: cannot open file 'libirc.lib' Can someone tell me the resolution for this problem?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend