Sunday, March 1, 2015

SQLCLR error Assembly in host store has a different signature than assembly in GAC Exception from HRESULT 0x80131050


I was referencing the "System.Drawing" DLL (Version 2.0.0.0) in my SQLCLR Assembly Project.
It was running fine for ages on the Server until i deployed a new version of my Assembly to it today:
Error message when you execute a CLR routine or use an assembly in SQL Server: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"

How-i-fixed-it:
I was able to fix my problem by executing this T-SQL command on my database:

Alter Assembly [System.Drawing]
From C:WindowsMicrosoft.NETFrameworkv2.0.50727System.Drawing.dll

The issue is also discussed here:
http://social.technet.microsoft.com/Forums/sqlserver/en-US/17df0715-7608-480d-8ad6-78dcf6c9d43a/different-version-in-gac-and-SQL

Link to Microsoft Knowledge Base Article:
http://support.microsoft.com/kb/949080
for details click below

1 comment:

  1. This blog is nice and very informative. I like this blog.
    blog Please keep it up.

    ReplyDelete