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 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.