tSQLtCLR Error

dmweyekdmweyek Posts: 21
edited May 18, 2012 2:10PM in SQL Test
I'm getting this when trying to create the assembly on SQL 2005 SP2.

CREATE ASSEMBLY for assembly 'tSQLtCLR' failed because assembly 'tSQLtCLR' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : tSQLtCLR.tSQLtPrivate::getTableStringArray][mdToken=0x6000012][offset 0x00000179] Unable to resolve token.
[ : tSQLtCLR.tSQLtPrivate::SqlDateTimeOffsetToString][mdToken=0x6000017] Type load failed.

Comments

  • Thanks for your post.

    At what point are you seeing this error?

    Does the account that you're using have enough permissions to install the framework and set the database to trustworthy?
    Chris
  • Thanks for your post.

    At what point are you seeing this error?

    Does the account that you're using have enough permissions to install the framework and set the database to trustworthy?

    I was finally able to successfully add the Testing Framework to that database. I had to reinstall/install .netframework 3.5 on the server and restart the server.
Sign In or Register to comment.