-
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?
-
Did you check SqlAccess.dll in that path on all nodes?
-
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.
-
Post the issue to microsoft sql2k5 newsgroup, maybe a bug.
-
Try moving the dll to the clustered disk and create assembly.
-
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
-
Forum Rules
|
|