SQL 2012 Hosting :: Deploy CLR in SQL Server 2012

Release time：2012-10-09
Browse：6497

The error message is

The following error might appear if you deploy a SQL CLR project that was built for a version of the .NET Framework that is incompatible with the target instance of SQL Server: “Deploy error SQL01268: CREATE ASSEMBLY for assembly failed because assembly failed verification”. To resolve this issue, open the properties for the project, and change the .NET Framework version.
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlClr.targets(96,5): Deploy error SQL01234: The database version is not supported.

I changed different version of .Net in the project. But it could not help.

Finally I figured that all CLR projects templates supporting prior SQL Server 2012 do not support SQL Server 2012. Microsoft SQL Server Data Tools has to be used. This tool is not installed by default. You have to go to New Project -> Other Languages -> SQL Server -> Microsoft SQL Server Data Tools.
About Eranet

Eranet International Limited(Eranet.com) was incorporated in Hong Kong in 2005, directly under Todaynic.com, Inc. which was established in 2000. As one of the first ICANN (The Internet Corporation for Assigned Names and Numbers), Verisign,HKDNR, and CNNIC (The China Internet Network Information Center) accredited registrars, Eranet is also a leading provider ofservices in domain name registration,web hosting and Email.
Promotion of Domain and Hosting selling with excellent discount:

Eranet International limited(www.eranet.com) as the icann ,cnnic and hkdnr accredit registrar .
We have the price Dot com $11.99, dot hk $22.63 ,dot cn $17.96 ,dot cc $46.16 each year.

You may click on our website for more detail
http://www.eranet.com/
http://partner.eranet.com/
Facebook:
http://www.facebook.com/pages/Eranet/258707884175692

Contact Info:
Skype Domainer27
MSN:sales@todaynic.com
Email:support@eranet.com
Tel:852-35685366

Document

Product Recommendation