How to implementing CLR in cluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to implementing CLR in cluster

Hi All, I want to implement clr on sql cluster 2005. Is there a specific way to do this?. Where should we copy the dlls do we need to keep them in a shared location so that any active node could access them or do we have any standard procedure for this.
Gautham.R

I haven’t seen any specific documentation talking about this on cluster and I believe the DLLs must be available on the both the nodes in order to workout during the failover. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
quote:Originally posted by r_gautham2001 Hi All, I want to implement clr on sql cluster 2005. Is there a specific way to do this?. Where should we copy the dlls do we need to keep them in a shared location so that any active node could access them or do we have any standard procedure for this.
Gautham.R
You should keep DLLs in SQL server BINN directory or some other folder on the shared drive not the local drive on both nodes if it is two node cluster. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

]]>