SQL CLR assembly as a remotable object

Question

Post reply

SQL CLR assembly as a remotable object

Nabha

SSCrazy Eights

Points: 8534
More actions
September 30, 2009 at 12:24 pm

#210213

I searched for a while about this and could not get any lead. Please forgive if its already discussed. Thanks.
I am creating a dot net remoting application. I have created one SQL CLR stored procedure which is acting as a client (in remoting) and a windows service application as a remoting host.
Planning to expose one SQL CLR assembly as a remotable server object. Is it possible please?
I mean, when a client calls a method on server(remoting server) it has to be executed in sql server memory. Hence the plan for exposing sql server assembly as a remotable server.
Any help is appreciated and please let me know if you need some more information. Thanks.
---------------------------------------------------------------------------------

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

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Remoting is not allowed because it doesn't follow the restrictions published in the BOL:

CLR Integration Programming Model Restrictions

Nabha SSCrazy Eights Points: 8534 More actions · Answer 2

Thanks Jonathan.

Yeah it looks like I am not going to make it but I made some progress with that. I created a clr stored procedure which configures an assembly( this could be an assembly outside sqlserver) using one configuration file. Since the process which is hosting this assembly is sqlserver, it would load that assembly in sqlserver memory for execution.

I placed this configuration file in the binn folder with the name as sqlserver.exe.config file. Although this is working and its hosting my server and one of the port which I am configuring is listening to the requests. But when I make a request from client, it thorws an error saying 'could not load the assembly'. I was assuming that loading of assembly would follow the 'normal' rule and look for the assembly in binn folder only (sqlserver.exe being the host) but I dont think its looking for the assembly there. Would plumb futher to identify if there is any way out.

Thanks agian. 🙂

---------------------------------------------------------------------------------

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 3

You can only access assemblies that are already added to SQL and a couple others, so basically you can't just reach out and access any DLL in the file system you want..

CEWII