SQL-DBA-01 (11/27/2016)
Hello,How to check whether the SQL Server reporting service is using :-
Reporting services Native mode,
or
Reporting Services Sharepoint Integrated Mode
It's listed in the Reporting Services Configuration Manager.
Or you can get the setting from the ConfigurationInfo table in the ReportServer database:
SELECT value
FROM ReportServer.dbo.ConfigurationInfo
where name like 'SharePointIntegrated'
Sue