SQL Server Performance

How to implementing CLR in cluster

Discussion in 'SQL Server 2005 Clustering' started by r_gautham2001, Jun 18, 2007.

  1. r_gautham2001 New Member

    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
    r_gautham2001, Jun 18, 2007
    #2

  2. satya Moderator

    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.
    satya, Jun 18, 2007
    #2

  3. MohammedU New Member

    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.
    MohammedU, Jun 18, 2007
    #2

Share This Page