USP_REPORTSERVERSETTINGS_GET

Loads settings about the report server setup.

Parameters

Parameter	Parameter Type	Mode
@WEBSERVICEURL	nvarchar(1024)	INOUT
@RENDERINGENGINEURL	nvarchar(1024)	INOUT
@REPORTDATASOURCE	nvarchar(1024)	INOUT
@USERNAME	nvarchar(1024)	INOUT
@PASSWORD	nvarchar(1024)	INOUT

Definition

Copy



create procedure dbo.USP_REPORTSERVERSETTINGS_GET
    @WEBSERVICEURL nvarchar(1024) = null output,
    @RENDERINGENGINEURL nvarchar(1024) = null output,
    @REPORTDATASOURCE nvarchar(1024) = null output,
    @USERNAME nvarchar(1024) = null output,
    @PASSWORD nvarchar(1024) = null output    
as

    set NOCOUNT on;

    select @WEBSERVICEURL = REPORTWSURL, @RENDERINGENGINEURL= REPORTRENDERURL, @REPORTDATASOURCE = REPORTDATASOURCE
    from dbo.INSTALLATIONINFO
    where [ID] = 1;


    exec dbo.USP_GET_KEY_ACCESS

    begin try
        select top 1
            @USERNAME = USERNAME,
            @PASSWORD = convert(nvarchar(1024), DecryptByKey(PASSWORD))
        from dbo.REPORTSERVERCREDENTIALS

        close symmetric key sym_BBInfinity
    end try
    begin catch
        close symmetric key sym_BBInfinity
    end catch

    return 0