I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network.
Then on my own PC (also on network) I open Report Manager website. I can see all reports fine. However, I get an error when attempting to run report. I then click on Datasource giving error and get this...
I have checked the domain server and the server hosting SSRS is added.
In SSRS Configuration Manager, the Authentication Type is
Service Credentials, and Username is
domain\SQLService. When I test the Database connection from here, all is ok.
Any ideas why this is not working? Looks like Kerberos is not the issue. Thanks.