SQL2005 report manager does not show all tabs (new folder, new data source, upload file,report builder)

Posted on 2010-03-27
Medium Priority
Last Modified: 2012-06-27
SSRS runs under window 2008, iis7 and I do have full admin right to the server but I can not get these tabs to show (http://localhost/reports)??

web site allows anonymous access
Question by:xyzlucky
  • 3
  • 2
LVL 16

Expert Comment

by:Megan Brooks
ID: 28815499
Are you trying to access RM directly from the server, is UAC turned on, and (if so) did you run IE as an administrator?

Author Comment

ID: 28819061
I am not sure What UAC means ... I tried to run the RM from a client XP machine (http://servername/reports) and from the server (http://localhost/reposts) and got the same result. I even connect to the report server where it stores the report and try to run it from there but I got the message 'access denied', can not create datasource, new report, etc...(Please see attached image)


Author Comment

ID: 28819204
I am pretty sure it is the permission problem but don't know where to set it
LVL 16

Accepted Solution

Megan Brooks earned 750 total points
ID: 28842992
UAC is the User Account Control feature in Windows Server 2008, Vista, and Windows 7. It will block your administrative access unless you run IE with administrator privileges. You would typically run into this only if you were trying to access RM locally on the web server. There might be issues, though, with remote IE clients as well if they are running on an OS that has UAC and if UAC is turned on. I finally just turned it off on my development PCs because of all the issues, but I leave it on on the Internet-facing web server.

Since your remote client is running XP, UAC would not be an issue there. If the web/report server is running with UAC, though, you might try logging on to that machine and accessing RM locally with IE, but running IE with admin privileges.

First, though, run IE locally on the report server the way you did before. If the status bar shows "Protected mode on" then UAC has disabled your admin privileges and you won't see much in the RM UI. If that is the case then exit IE, right click an IE shortcut (such as the one in the Quick Launch bar, or find IE in the Start menu), and select "Run as administrator." If that lets you see all the tabs (Protected Mode should now be "off") then at least you know that RM itself is working.

Author Closing Comment

ID: 31707886
It is still a mystery to me. I finally had to reinstall the report server and redeployed the reports (because of time constraint).


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question