Red Gate forums :: View topic - tSQLtCLR Error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Test
SQL Test forum

tSQLtCLR Error

Search in SQL Test forum
Post new topic   Reply to topic
Jump to:  
Author Message
dmweyek



Joined: 16 May 2012
Posts: 13

PostPosted: Wed May 16, 2012 12:55 am    Post subject: tSQLtCLR Error Reply with quote

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.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu May 17, 2012 2:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
dmweyek



Joined: 16 May 2012
Posts: 13

PostPosted: Fri May 18, 2012 7:10 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group