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

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

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

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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



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

Permission Errors for Users on Home Page only of SQL Server Reporting Services Report Manager

I have spent days now investigating this problem, so any help very much appreciated! I have a remote web server 2003 running SQL Server R2 Express Edition with Reporting Services installed. I use Report Builder 3.0 locally to build report. If I login via Internet to Report Manager Web Page as an administrator I can perform all the expected and required actions, creating new folders and assigning permissions for users etc. I have added a new user "ReportUser" as a Browser of a child folder. If ReportUser longs on to home page, he receives the all too familiar error: User 'XXXXXXXX\reportuser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. However, if the user starts at the child folder of home page, and then logs in, he sees the expected page, and can run the report!  This is not very satisfactory. How can I allow user to see home page, without an error message, but not be allowed to click on any folders to which he is not entitled? I am now aware that SQL Server R2 Express Edition has many limitations compared with full Editions (fixed roles, cannot manage Report Service from Management Studio etc) , and many of the "solutions" offered on the web just do not apply.   John Walton

Don't see tab and toolbar of the report manager application after installing sql server reporting s

Hello everyone: I have tried to install and configure Reporting Service. I found lots of  errors along the way. The first one was an error (500.23) from IIS7. I applied the suggested solution on the IIS screen which was migrating configuration using AppCmd ( %SystemRoot%\system32\inetsrv\appcmd migrate config "Default Web Site/"). Next problem was  : Request is not available in this context Stack Trace: [HttpException (0x80004005): Request is not available in this context] System.Web.HttpContext.get_Request() +3465893 Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +47 Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32  This error was caused by the fact that Report Server and Report Manager were configured to DefaultAppPool in the Reporting Service Configuration Manager. I have switched to Classic .Net AppPool  for both Report Server and Report Manager and it has fixed the problem. Now my problem is that the Report Manager Application ( http://localhost/reports/folders.aspx ) shows no tab, toolbar or folder. What I now have on the Report Manage Application page is the header with the title and [home] and [Help] button links on the top right corner. I have made a report to test the problem but no folder shows o

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.

Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + sym


Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + symbol and if i click okn + it should show all the folders and fils in the folder

+ Columbila

If i click the + symbol it should like below

- Columbia

      - Reports





SQL Server 2008 Report Manager is not fully working



On Windows server 2008 R2 Enterprise Edition, we have installed SQL server 2008 R2 Reporting services and SQL Server 2008 database with Reporting services.  Both have different instances.

Now, we can work with Report manager of SQL server 2008 R2 without any issue. i.e. assignment of new user role etc. is working fine, but when we try to do same thing with report manager of sql server 2008 then its not working. No error message is being shown by the report manager when we try to assign new user a role and press OK button it doesn't show any message.


What could be the problem?





My report manager url getting error (Error:This operation is not supported on a report server that i


Hello Friends,

 I am MD.Liakath ali new to sharepoint  , I need Report Server as fine without errors,  bcz after installatino My Report manager URL getting error. I want to genrate a report based on 2 or more list columns in sharepoint 2010 in report server.

For reporting config manager i installed like as bellow:

1. At the time SharePoint 2010 installation in standalone server"Reporting Services Feature is in Native Mode".
2. Add-In s/w installed and configured with rsCustomAction.exe /i this cmd,
3. Enabeled TCP/IP in SQL server config manager "MSSQLSERVER TCP/IP Enabled"
4. I opened Reporting Services Config Mannager as administrator:
                      In service a/c: Selcted 'Network Service',
                      Created Database in sharepoint integrated mode,
                      Local Instance of sql server Authentication Type: Current Integrated se

Report Server Instance not shown in SQL 2008 R2 version for Configuration Manager



I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2

I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.

But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:

http://Server IP/Reports_SQL2008R2/Pages/Folder.aspx

In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "

How to get the Report server instance name in the configuration manager.

Thank you

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!


In Sharepoint Integrated Mode whether Report Manager URL http:///Reports will open the


Hai Friends,

                I am Ali, In SharPoint Integrated mode ReportManager URL getting This Error [ This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) ].

1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.

2  In Reporting service config manager tool http://<serverName>/Reports URL is working in 'Native mode' as Fine. Here i am able to create New Roles and able create New Folders and able to deploy the Reports from BIDS and Report Builder to Report Server.

3. Now , I opened Reporting Services Config Manager Tool and I Created New Data Base(as 'ReportServerTest) In sharepoint Integrated mode.

4. ReportServer Configured Reporting Services in SharePoint Integrated mode Sucsessfully. Granted Data base.

4. Enabled Content Types Sharepoint Library and i am able to deploy .rdl files from BIDS(Designer) to sharepoint library.

5. But i need to Deploy the Reports from Report Builder 3.0 to Report Server In SharePoint Integrated Mode

I Want to op

SSRS Report Manager and Server do not work outside of Head Office



Good Day

We have recently started to transfer our current GP8 system into GP10 for the Head Office and CRM for our stores.  The stores no longer have access to Great Plains so we have re-created all the smartlists they used in GPO8 into SSRS and have published them to the Report Server (using SSRS 2008), the problem is they are unable to access the data via //{hostmachine}/reports or //{hostmachine}/reportserer.

CRM is no problem (via //{hostmachine}:5555/) and again any reports within CRM running off of companyname _MSCRM database, but accessing the report manager or report server brings back a blank page; not even the headers:



The odd thing about it is that it generates no error which has made it difficult for me to search for a solution. 

I have tried adding port numbers 80 and 8080 to the url link but to no avail.  I do not believe it is a credentials issue as a logon prompt does not pop-up (where as every time CRM loads it requests for the user's credentials).  The only thing I have noticed is that if it's someone within the Head Office or someone who has VPNed onto our server it is fine (Head office ip 192.168.247.xxx, the VPN gives an address within the same range). The

Last user permission in SQL server Report Manager overwrite previous permission


I have successfully customized form authentication for SQL Server 2008 reporting services. SQL Server 2008 report manager page is worknig fine and it used database users to do login. Now I found one big problem. If user_1 (normal user) login in report manager, and then keep browser open. At this time, Admin user login report manager at same machine, but open another browser. At this time, when user_1 click any button/link or refresh page, user_1 will have Admin user permission.

Any one has any idea ? what is my problem and  how can I debug it ?




A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


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.

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

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