Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swd1974
Starting Member
7 Posts |
 Posted - 2011-01-24 : 10:36:01
|
| Not sure what I am not doing correctly to view the web interface for reporting services.I am running 2008 R2 on a windows 7 box.I have it set up to use my windows account user which has sysadmin rights. I have TCP/IP enabled. I have Agent and DTC running.I went through Reporting configuration and when I click on either of the links (Web Service URL and Report Manager URL) and get a 404 error.I have tried both network, local service accounts, my windows domain user account which has local admin rights.When I deploy a report from BIDS I get a "could not connect to the report server http://127.0.0.1/ReportServer. The server committed a protocol violation. Section=ResponseStatusLine) error.Report Builder 3.0 also will not connect and says it is offline or not available. Thoughts? Thank you! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-24 : 12:05:48
|
| seems like reporting services is not running. can you check it in sql server services?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
swd1974
Starting Member
7 Posts |
Posted - 2011-01-24 : 12:15:05
|
| Yes it is running. In SQL Server Configuration manager next to SQL Server reporting services it has the icon with the green running icon but also has a small red quare on it as well. Dont know if that means anything. But the state is running. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
swd1974
Starting Member
7 Posts |
Posted - 2011-01-24 : 12:26:13
|
| I cannot access report manager via the url provided in the configuration. I set everything up though the Reporting Services Configuration manager.Little req square (you can barely see it is in the lower left corner of the icon. |
|
|
|
swd1974
Starting Member
7 Posts |
Posted - 2011-01-24 : 12:46:07
|
| Well I got something different. Im on a 32 bit machine and changed the port in Reporting Services Configuration manager to 8080Then I got this error"The permissions granted to user 'myusername' are insufficient for performing this operation. (rsAccessDenied)Now myusername has sysadmin rights to the instance as well as dbowner to both ReportServer databases. |
|
|
|
|
|
|
Viewing Report Server URL