RDS Assemblies Activation Test

Documentation

--Create an assembly from inline code
CREATE ASSEMBLY [CLRTest]
FROM
0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030003A5F8550000000000000000E00002210B010B00000800000006000000000000FE250000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000B02500004B00000000400000A002000000000000000000000000000000000000006000000C000000782400001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000004060000002000000008000000020000000000000000000000000000200000602E72737263000000A00200000040000000040000000A0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000E00000000000000000000000000004000004200000000000000000000000000000000E025000000000000480000000200050094200000E40300000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002002E0000000100001100280500000A0A7201000070280600000A0C1202FE16090000016F0700000A280800000A0B06076F0900000A002A1E02280A00000A2A000042534A4201000100000000000C00000076342E302E33303331390000000005006C00000050010000237E0000BC0100007001000023537472696E6773000000002C030000340000002355530060030000100000002347554944000000700300007400000023426C6F620000000000000002000001471402000900000000FA253300160000010000000A00000002000000020000000A0000000400000001000000010000000200000000000A00010000000000060037003000060061004E000B00750000000600A40084000600C40084000A001101F6000A002701F6000A003201F60006004301300006005D0130000000000001000000000001000100010010001600000005000100010050200000000096003E000A0001008A2000000000861848000E000100110048001200210048001800290048000E00310048000E0039003A01220049004C012700090054012C0051006401300041006B013600090048000E00200023001D002E000B0043002E0013004C002E001B0055003B00048000000000000000000000000000000000E200000004000000000000000000000001002700000000000400000000000000000000000100EA00000000000000003C4D6F64756C653E00434C52546573742E646C6C0053746F72656450726F63656475726573006D73636F726C69620053797374656D004F626A65637400434C52535054657374002E63746F720053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500434C52546573740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E5365727665720053716C50726F6365647572654174747269627574650053716C436F6E746578740053716C50697065006765745F50697065004461746554696D65006765745F4E6F7700546F537472696E6700537472696E6700436F6E6361740053656E6400002F430075007200720065006E0074002000530079007300740065006D0020004400610074006500200069007300200000000000D396EBA6B77A504F92EB708065A81EE00008B77A5C561934E089030000010320000105200101110D04200101080401000000040000122104000011250320000E0500020E0E0E042001010E07070312210E11250801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000003A5F85500000000020000001C0100009424000094060000525344530AED3A94D599A44193E9AE3492FB0C6303000000633A5C55736572735C6A656D746563683030385C446F63756D656E74735C56697375616C2053747564696F20323031335C50726F6A656374735C434C52546573745C434C52546573745C6F626A5C44656275675C434C52546573742E706462000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000D82500000000000000000000EE250000002000000000000000000000000000000000000000000000E02500000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000440200000000000000000000440234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004A4010000010053007400720069006E006700460069006C00650049006E0066006F0000008001000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000038000C00010049006E007400650072006E0061006C004E0061006D006500000043004C00520054006500730074002E0064006C006C0000002800020001004C006500670061006C0043006F00700079007200690067006800740000002000000040000C0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000043004C00520054006500730074002E0064006C006C000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000003600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = SAFE

-- Create a Stored Procedure that will invoke the assembly
CREATE PROCEDURE [dbo].[CLRSPTest]
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [CLRTest].[StoredProcedures].[CLRSPTest]
GO

-- If the stored procedure is executed, it will fail to execute the assembly, because it is not activated.

exec dbo.CLRSPTest

-- The following error will be reported:

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

- In order to activate the assembly the following command need to be exeuted:

sp_configure 'clr enabled',1
reconfigure

-- The RDS root account does not have sufficient permission to execute above. The following error will be reported:

User does not have permission to perform this action.