SQL Server 2008 R2/2012/2014

  • Hello,

    How to check whether the SQL Server reporting service is using :-

    Reporting services Native mode,

    or

    Reporting Services Sharepoint Integrated Mode

    Thanks.

  • 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

  • Thnkx Sue

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply