Solved

MSSQL 2008 reporting service on Windows Server 2008 not working

Posted on 2011-03-15
13
339 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A procedure for exporting installed hotfix details of remote computers using powershell
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…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

863 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

23 Experts available now in Live!

Get 1:1 Help Now