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.
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
, and it returns SQL rather than Kerberos. Yet no issues with remote database from here. Also I ransetspn -l domain\serviceaccount
on the domain controller and the new server is listed.domain\serviceaccount
I get permissions granted to mySSRSserver\Administrator are insufficient (rsaccessdenied). I do not know why it thinks I am using SSRS server admin login when logging in from my own PC?? Tested on other user pcs and works fine!