USP_REPORTSERVERCREDENTIALS_EDIT

Updates the report server credentials

Parameters

Parameter	Parameter Type	Mode	Description
@USERNAME	nvarchar(1024)	INOUT
@PASSWORD	nvarchar(1024)	INOUT

Definition

Copy



create procedure dbo.USP_REPORTSERVERCREDENTIALS_EDIT
(
    @USERNAME nvarchar(1024) = null output,
    @PASSWORD nvarchar(1024) = null output    
)
as
begin
    declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    exec dbo.USP_GET_KEY_ACCESS;

    begin try
        if exists (select top 1 1 from REPORTSERVERCREDENTIALS)
            update REPORTSERVERCREDENTIALS
            set [USERNAME] = @USERNAME, [PASSWORD] = EncryptByKey(Key_GUID('sym_BBInfinity'), @PASSWORD),  [CHANGEDBYID] = @CHANGEAGENTID, [DATECHANGED] = getdate();
        else
            insert into REPORTSERVERCREDENTIALS ([USERNAME], [PASSWORD], [ADDEDBYID], [CHANGEDBYID])
            values (@USERNAME, EncryptByKey(Key_GUID('sym_BBInfinity'), @PASSWORD), @CHANGEAGENTID, @CHANGEAGENTID);
    end try
    begin catch
        close symmetric key sym_BBInfinity;
    end catch
end