5 สิงหาคม 2551 18:50
I have problems accessing my reports after moving the sql-server to another machine:
Everything works well after moving to the new machine except the reports.
As we moved from 32-bit to 64-bit sql-server we couldn't just detach/attach the reportserverdatabases, as the format of the tables is different from 32 to 64bit.
The Reportserver is on the same machine as the sql-server. The new machine has the same IP.-Nr. an Name as the old and I added all AD Groups for the CRM-System to the new databases. (As I mentioned everything works fine..so far..)
We published the reports with the deployment-Manager for CRM.
First we installed an old machine with reportingservices then we took deployment-manager to switch over to this RS. After that we switched back to the new one. (This was necessary, because we could'nt run DeploymentManager without changing the ReportServeradress!).
After that I can look at the report when I call the reportserver-url directly but not when using webinterface of crm.
I reinstalled the Connector but it didn't help at all.
My logs tell me that the access for the user nt-authority\network service is denied.
Wich Credentials do I have to allow Access on wich level to what?
5 สิงหาคม 2551 19:57
OK, I found the solution:
The AppPool-Accounnt for the Virtual Directorys Reports and ReportsServer changed to NT-Authotity\NetworkService and everything is running...
- ทำเครื่องหมายเป็นคำตอบโดย Donna EdwardsMVP, Owner 2 กรกฎาคม 2552 15:41
6 สิงหาคม 2551 12:13ผู้ดูแล
yes its app pool issue.
nice to see you got working