We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.
We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.
I was able to publish my 2005 reports using VS 2005 easily.
1) But when I try to run the reports I am getting below errors at my website home page.
The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)
I could not get why there is no user name in above error and how it says machine name does not have permissioin?
There should be at least some user id mentioned as per me.
What could be the reason of above error?
2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.
"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.
What should I be doing to resolve above errors?
View Complete Post