Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSSQL 2008 reporting service on Windows Server 2008 not working

Posted on 2011-03-15
13
Medium Priority
?
347 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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 2000 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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…
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…

972 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