Solved

MSSQL 2008 reporting service on Windows Server 2008 not working

Posted on 2011-03-15
13
342 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
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…

828 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