tSQLtCLR Error

dmweyek

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.

Chris Auckland

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?

dmweyek

Chris Auckland wrote:

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.