MSSQL 2008 reporting service on Windows Server 2008 not working

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
CybrisbobAsked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
CybrisbobAuthor Commented:
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Daniel_PLDB Expert/ArchitectCommented:
Can you check your reporting services setting in reporting services configuration manager?

http://www.mssqltips.com/tip.asp?tip=1453
0
 
CybrisbobAuthor Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
Have you tried to run Internet Explorer as an administrator?
0
 
CybrisbobAuthor Commented:
Yeah have tried that too, no luck either.
0
 
CybrisbobAuthor Commented:
Have done this, no change. Still just see a header and no options.
0
 
Daniel_PLDB Expert/ArchitectCommented:
I've forgotten, restart your reporting services service after change in configuration manager, sorry.
0
 
CybrisbobAuthor Commented:
Daniel I will come back to you tomorrow regarding this, again thanks for your efforts thus far.
0
 
CybrisbobConnect With a Mentor Author Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
I'm glad it's working now.

Take care,
Daniel
0
 
CybrisbobAuthor Commented:
Reinstalled on a new server working now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.