Consuming Reporting Services Webservice via .NET CLR Stored Procedure

[RobHudson]

Hi

I'm beating myself up over trying to get my SQL CLR stored procedure working with the Reporting Services webservice (

http://server/reportserver/reportservice.asmx).

With out the webservice call, the process runs correctly. When I add it I get the following error:

Error: Cannot load dynamically generated serialization assembly. In some hosting environments assembly load functionality is restricted, consider using pre-generated serializer. Please see inner exception for more information.
Inner Exception: System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.
   at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection)
   at System.Reflection.Assembly.Load(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence securityEvidence)
   at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
   at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
   at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
   at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
   at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)

I have done some hunting about on this (thanks google!) and now understand why I get the error - I think...

It seems that I need to register the webservice assembly on the SQL Server (using CREATE ASSEMBLY) - fine! Problem is what assembly do I register for the webservice and is that correct way to do this?

So to sum up: I need to know who to consume the Reporting Services webservice via a .NET CLR Stored Procedure

Sorry if this is the wrong forum to post in. If so, let me know

Cheers
Rob