Solved

MSSQL 2008 reporting service on Windows Server 2008 not working

Posted on 2011-03-15
13
344 Views
Last Modified: 2012-05-11
Hi All

I have an issue, Windows 2008 standard edition running II7, MSSQL 2008 and MSSQL 2008 reporting service.

Problem:
The report manager http://localhost:8080/Reports prompts for login, use admin account to log in but only see the header and no options to set permissions for clients and reports.

I have tried the UAC trick off, reboot, check site that same so I turned it on again, no luck still does not display anything.

I have tried adding the sties to the trusted sites section with no luck.

This has frustrated me for a few days now and all suggestions I have found have not produced further results.

I need to get into the report manager to configure permissions for clients to us the reporting tool.

Thanks in advance.

- Cybrisbob
0
Comment
Question by:Cybrisbob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35138173
Please see this:
http://msdn.microsoft.com/en-us/library/aa337491%28v=SQL.100%29.aspx

If you see something like this, you can assign roles in properties tab (as described in the tut posted above):
 reports
0
 

Author Comment

by:Cybrisbob
ID: 35138270
Hi Daniel

I only see the top part, I do not get any options below the header. Screen shot attached.
 report screen shot
Thanks

- Jay
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35138391
Can you check your reporting services setting in reporting services configuration manager?

http://www.mssqltips.com/tip.asp?tip=1453
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Cybrisbob
ID: 35138427
Hey

Using 2008 version which does not have allot of options but all is green and happy. I get no error's when setting the configuration options.

Thanks
- Jay
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35146357
Have you tried to run Internet Explorer as an administrator?
0
 

Author Comment

by:Cybrisbob
ID: 35147474
Yeah have tried that too, no luck either.
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35147771
Try adding that site to Local Intranet sites.
Go to reporting services configuration manager -> configuration manager url -> advanced -> add
Set all default with port 80
Then go to IE and try http://localhost/Reports
0
 

Author Comment

by:Cybrisbob
ID: 35147999
Have done this, no change. Still just see a header and no options.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35148059
I've forgotten, restart your reporting services service after change in configuration manager, sorry.
0
 

Author Comment

by:Cybrisbob
ID: 35148091
Daniel I will come back to you tomorrow regarding this, again thanks for your efforts thus far.
0
 

Assisted Solution

by:Cybrisbob
Cybrisbob earned 0 total points
ID: 35204876
Hi Daniel

I have installed a vm with Windows 2008 and MSSQL 2008 and reporting service 2008 and this works out of the box.

Many thanks for your help, when you reply I will award the points to you for your efforts.

Thanks
Jaysen
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35206290
I'm glad it's working now.

Take care,
Daniel
0
 

Author Closing Comment

by:Cybrisbob
ID: 35239025
Reinstalled on a new server working now.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

630 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