tSQLtCLR Error

Easy unit testing for databases in SQL Server Management Studio

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, David Priddle

tSQLtCLR Error

Postby dmweyek » Wed May 16, 2012 12:55 am

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.
dmweyek
 
Posts: 13
Joined: Wed May 16, 2012 12:53 am

Postby Chris Auckland » Thu May 17, 2012 2:54 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby dmweyek » Fri May 18, 2012 7:10 pm

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.
dmweyek
 
Posts: 13
Joined: Wed May 16, 2012 12:53 am


Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests