Start a project on my Dev Server.
SQL 2012 with CU1 and CU2 are installed on both Coding Server and Dest Server
Start project on Dev server.
Pick vb.net CLR project type
name project something random...
setup connection to destination server/database
Use .net framework 4.0 (installed on both servers and verified the framework is the same version)
To verify framework SQL 2012 is using I ran this command on the Dest server:
select * from sys.dm_clr_properties
state CLR is initialized
Verified the Database I'm deploying to has Trustworthy set to ON
added a Stored procedure to the project.
Did not add any code to the stored procedure.
Build the project (successful)
Deploy the project I get:
Beginning deployment of assembly TestCLRProject.dll to server OLTP : MyDatabase
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.
Time Elapsed 00:00:00.01
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
Anybody have any ideas?