CONFIGURING SQL SERVER REPORTING SERVICES

I'm having problems configuring SQL Server Reporting Services to serve up Reports and use the Report Builder.
(I'm using SQL Server 2005 deployed on a Windows 2003 server - called we'll say SERVER1)
On my development machine (DEVELOPMENT 1) i can create reports and models and "deploy" them to SERVER1. I can also preview my reports.
On SERVER 1 I can see the newly created reports and model in SQL Server Management Studio.
When I (logged on to SERVER1) go to https://localhost/Reports$XXX/Pages/Folder.aspx, I can see my newly created reports (i.e. the links for them) and model however when i try to connect to view the contents of the report I get the following error

Logon failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

On my SERVER 1 Virtual Directories Reports and ReportServer I have anonymous access switched off and integrated security switched on.
In the report services configuration manager all looks OK except the Web Service Identity has a red X beside it and when viewing this page the ASP.NET service account is disabled and blank.

Any ideas?
CMSIRLAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
Ashok KumarCommented:
use your web.config file to set the web service identity and then try after restarting reporting services.
0
 
CMSIRLAuthor Commented:
what key do I use and what should I be setting it to?
0
 
CMSIRLAuthor Commented:
I got the webservice identity problem fixed by deleting the virtual directories and recreating them using the Report Services Configuration Tool.

I'm still have this problem though when I try to access the reports themselves

Logon failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

Any ideas?
0
 
CMSIRLAuthor Commented:
I fixed this by giving the account specified as the execution account in Report Services Configuration Tool administrative priveleges on the server hosting SSRS
0
All Courses

From novice to tech pro — start learning today.