.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

Missing Tabs in SQL Server Reporting Sevices Home

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

I am running SQL Server 2008/Windows 7

I have looked at several answers to this but dont really understand the answers fully enough.

If i enter http:\\computername\reports I just get a blank home page.  Many answers say this is to do with privileges but give less than clear instructions about how to remedy 

for example...


 tells me..

"try this: In computer management browse your reports virtual directory. Right click on it and select properties. Choose directory security tab. Under authentication and access control click edit. Uncheck enable anonymous access. Ok. Ok"

it may be dumb question but what is 'computer management' and where is the reports virtual directory?  I cant find 'authentication and access control'  - is it different in Windows7?

what is the difference (if any) between Local Admin and Administrator user?

any help appreciated.


View Complete Post

More Related Resource Links

SQL Server Reporting Services not able to install on Windows Vista Home Premium


Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.

But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.

Reference: http://support.microsoft.com/kb/920201/en-us

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

{ End Bracket }: Customize Windows Home Server


Chris Gray discusses custom applications he's developed for Windows Home Server and explores applications for energy savings.

Chris Gray

MSDN Magazine July 2008

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

Data Points: Designing Reports with SQL Server Reporting Services 2005


Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services


SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services


SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

All my server-controls became unrecognized!!! like there's compilation error or web.config missing!



please help - the problem is in post subject.

I have lots of warnings with following text:

"Warning 10 Element 'HyperLink' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:\Users\Pavel\Documents\Visual Studio 2010\WebSites\BioWebSite\ToScientist.aspx 26 18 C:\...\BioWebSite\" 

But web.confg is there! And there's no compilation error!

Site builds just fine. And If I upload it to my hoster - it works!


But with all these errors I cant add controls to pages - VS2010 adds hyperlink without ID, and intelisens stoped to work.

Strange, but in my other project (web-application) I have no such difficuty.

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Error while confguring the MOSS reporting server

I am getting following error " A new member could not be added to a local group because the member has the wrong account type
 " while granting database access from Central Administration > Configure Reporting Services Integration   -> Grant Database Access .

RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service


I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

SQL Server 2005: Install reporting services - which version?

Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

SQL Server 2008 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n
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