October 30, 2007 at 6:36 pm
Hi, I have a sql server 2005 on a windows 2000 machine. I installed sql server 2005 but when I went to Reporting services config I can't get web identity to work, the text box is blank. when i click on apply it gives me this error
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070005
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
on the report manager it gives me this error
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
any ideas on what to do? I also went to rsconfig file and added IWAM_machinename to the webserviceaccount element like most ppl said to do. But that still dont work.
Please help me
Thanks in advance
October 31, 2007 at 7:43 am
Can you get on to Database setup tab and check Credential Type you are using. Basically from your error, it seems that you do not have access previleges to modify your reportserver database. So you may have to generate a script with Grant Rights option selected and execute it. Then you should be able to access your report server.
Prasad Bhogadi
www.inforaise.com
October 31, 2007 at 4:30 pm
Hi thanks for the reply,
I did that but still no luck
November 1, 2007 at 10:37 am
Try restarting the Windows Management Instrumentation service on the RS box
November 2, 2007 at 6:41 pm
Hi, it finally work after reinstalling it. Turn out that i have to set it to network service instead on putting in the domain administrator account.
Thanks all
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply