Solved

MSSQL 2008 reporting service on Windows Server 2008 not working

Posted on 2011-03-15
13
338 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
  • 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
 

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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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 book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now