Trying to CREATE ASSEMBLY in MS SQL Server 2012 SP1.
Assembly was developed in Visual Studio 2010 as a SQL Server Database Project targeting SQL Server 2012 platform and .NET Framework 4.
It references Google.Apis.Admin.Directory.directory_v1 as well as other DLLs included in the nuget package for this assembly.
Create ASSEMBLY [XXXX] from
'C:\Visual Studio 2010\Projects\XXXX\XXXX\bin\Debug\XXXX.dll'
WITH PERMISSION_SET = UNSAFE;
Returns the following error.
Msg 10301, Level 16, State 1, Line 1
Assembly 'XXXX' references assembly 'mscorlib, version=18.104.22.168, culture=neutral, publickeytoken=7cec85d7bea7798e.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.
Has anyone encounter this issue?