Results 1 to 6 of 6

Thread: CLR Assembly issue Clustering SQL server

  1. #1
    Join Date
    Nov 2002
    Posts
    231

    CLR Assembly issue Clustering SQL server

    Hi
    I'm trying do the below in SQL Server Clustering Environemnt.

    create ASSEMBLY CLR_code

    FROM C:\MSSQL\MSSQL\CLRcode.dll'

    WITH PERMISSION_SET = SAFE

    But getting the below error.
    Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\'.

    anbody face this kind off issue and any solution for me?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you check SqlAccess.dll in that path on all nodes?

  3. #3
    Join Date
    Nov 2002
    Posts
    231
    Yes, it is there. I checked the file size and date also. It same as in my local box which is running correctly. I have tested another two box with no cluster envrioment and all are running fine.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Post the issue to microsoft sql2k5 newsgroup, maybe a bug.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try moving the dll to the clustered disk and create assembly.

  6. #6
    Join Date
    Nov 2002
    Posts
    231
    Skhanal,
    I have tried the same but didn't work though. Finaly it is working after restart the server.
    Thanks for your comments.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •