An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536

Question

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536

Nicky 121

We have moved our SQL Database to SQL Server on Azure VM.

I have already ran these

USE SSISDB
GO
EXEC sp_changedbowner 'sa'

Alter database SSISDB SET Trustworthy ON

I am trying to deploy the package and create a folder but I still gettign this error:

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'microsoft.sqlserver.integrationservices.server, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)
System.IO.FileLoadException:
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
(Microsoft SQL Server, Error: 10314)

Shivendoo Kumar 751 Reputation points

2021-07-27T01:14:47.017+00:00

I restored SSIS DB from one server to another and I was getting errors when was deploying SSIS packages.

https://sqlwithmanoj.com/2016/06/22/sql-error-the-server-may-be-running-out-of-resources-or-the-assembly-may-not-be-trusted-with-permission_set-external_access-or-unsafe/

https://blog.pythian.com/how-to-fix-ssis-deployment-error-please-create-a-master-key/

Luckily I had the password so fixed it using the below qurery.
open master key decryption by password = ‘P@ssword!’
Alter Master Key Add encryption by Service Master Key
Claudia Cavalcante Pires 0 Reputation points

2023-09-14T13:50:59.1266667+00:00
That solution worked for me too, but now I'm having a problem with encryption:

'Please create a master key in the database or open the master key in the session before performing this operation. (.Net SqlClient Data Provider)'

I restored from one server to another server and I don't have the original password, I tried to backup the master key, but the restore like the site shows return this:

'Incorrect syntax near 'password'.'
The syntax that I used:

Restore master key from file ='\meuservidor\Backup\masterkey.backup' Decryption by password = 'password'

I tried this too, and didn't works again:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'; RESTORE MASTER KEY FROM FILE = '\\meuservidor\Backup\masterkey.backup' DECRYPTION BY PASSWORD = 'password' ENCRYPTION BY PASSWORD = 'passwordx'; GO

2 answers

Your answer

Shivendoo Kumar 751 Reputation points

2021-07-27T01:14:47.017+00:00

I restored SSIS DB from one server to another and I was getting errors when was deploying SSIS packages.

https://sqlwithmanoj.com/2016/06/22/sql-error-the-server-may-be-running-out-of-resources-or-the-assembly-may-not-be-trusted-with-permission_set-external_access-or-unsafe/

https://blog.pythian.com/how-to-fix-ssis-deployment-error-please-create-a-master-key/

Luckily I had the password so fixed it using the below qurery.
open master key decryption by password = ‘P@ssword!’
Alter Master Key Add encryption by Service Master Key
Claudia Cavalcante Pires 0 Reputation points

2023-09-14T13:50:59.1266667+00:00

That solution worked for me too, but now I'm having a problem with encryption:

'Please create a master key in the database or open the master key in the session before performing this operation. (.Net SqlClient Data Provider)'

I restored from one server to another server and I don't have the original password, I tried to backup the master key, but the restore like the site shows return this:

'Incorrect syntax near 'password'.'
The syntax that I used:

Restore master key from file ='\meuservidor\Backup\masterkey.backup' Decryption by password = 'password'

I tried this too, and didn't works again:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'; RESTORE MASTER KEY FROM FILE = '\\meuservidor\Backup\masterkey.backup' DECRYPTION BY PASSWORD = 'password' ENCRYPTION BY PASSWORD = 'passwordx'; GO

Answer 1

Gregory Liénard 111

@Nicky I had the same problem. It's all about the order of execution:

First make sure that the database is CLR enabled: USE [myDB]
EXEC sp_configure 'clr enabled', 1
RECONFIGURE
Set it to thrusthworthy: ALTER DATABASE myDB SET TRUSTWORTHY ON;
Change owner to SA: EXEC sp_changedbowner 'sa'

That should do it.

Zeek2 6 Reputation points

2021-08-31T09:49:16.907+00:00

The above worked for me. I can also confirm that the final change of database owner to sa was necessary. Thanks :)
Vajner Martin 1 Reputation point

2021-12-15T08:25:37.583+00:00

Yes I confirm, this solution is correct and worked over the database. Thank you
Hemmder Alvarez 1 Reputation point

2022-10-20T14:22:04.037+00:00

@Gregory Liénard Thanks!!
The same thing happened to me after doing a restore from another database.
Kenneth W Herrscher 1 Reputation point

2023-01-06T18:25:57.297+00:00

We restored a database from one of Cloud Vendor's SQL server to one of our internal SQL Servers, and experienced this same error message. Gregory-Lienard's post worked for me. Thanks, Gregory-Lienard!
James O’Donnell 0 Reputation points

2023-01-31T10:46:45.2633333+00:00

Thank you :)
Rajaganesh Ramachandran 0 Reputation points

2023-06-04T16:12:29.3+00:00

Excellent Greg, That did the trick !!
Siraj 0 Reputation points

2023-06-04T16:13:32.3+00:00

Thanks Greg
That Really worked
Johnny Serrano 0 Reputation points

2023-07-07T13:24:13.2566667+00:00

Step 2 of the suggestions worked great for me. Thanks!

But a word of caution; I had the database in an SQL Availability Group so any changes to the database in the primary replica should be "replicated" out to the secondary replica, right? Wrong! So, why did this change not take effect on the secondary node and instead had me execute Step 2 on it? I haven't tried other database properties but this is somewhat concerning if some database properties are not getting sync'ed up.
Laxmidhar Behera 0 Reputation points

2023-08-14T06:18:07.0166667+00:00

Yes, this solution worked for me, Thank you.
Jhonatan Rico 0 Reputation points

2024-08-08T18:15:35.9866667+00:00

This solution worked for me. When I made a backup and restored the database, the DatabaseOwner appeared as null. I verified the DatabaseOwner with this query: SELECT USER_NAME(owner_sid) AS DatabaseOwner, * FROM sys.databases WHERE name = '<database_name>'; It's important to mention that this solution CAN BE POTENTIALLY INSECURE and should be applied with caution. The ideal approach is to configure the assembly to be secure (related post here: https://dba.stackexchange.com/questions/142369/net-sqlclr-assembly-not-working-in-sql-server-2016-error-msg-10314).
Sara Fallah 0 Reputation points

2024-10-08T07:40:11.5866667+00:00

Thanks
Henry Ma 1 Reputation point

2025-05-20T13:39:59.6033333+00:00

This works for me as well! I'm not certain if all steps were needed, but I followed all steps and now I'm good! Thank you Greg!

Answer 2

Monalv-MSFT 5,926

Hi @InderjeetKaur-3272,

Could you please share the version of your SQL Server?

May I know if you Install Integration Services(SSIS)?

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Monalv-MSFT 5,926 Reputation points

2020-10-09T08:23:40.033+00:00

Hi @InderjeetKaur-3272,

May I know if you have anything to update?

Best Regards,
Mona
Nicky 121 Reputation points

2020-10-09T08:30:40.43+00:00

@Monalv-MSFT My version of SQL server is 15.0.18338.0.

Yes we have SSIS installed and we run packages every week using SSIS. We were trying to create one of these package.

If I try to add any folderor new package under SSISDB, I get this error. I am not able to deploy the package.

Thanks !
Monalv-MSFT 5,926 Reputation points

2020-10-09T09:25:47.957+00:00

Hi @InderjeetKaur-3272,

Please set TargetServerVersion as SQL Server 2019 in SSIS project.

Best Regards,
Mona
Nicky 121 Reputation points

2020-10-09T09:57:48.06+00:00

Target server version is 2019 only.
Monalv-MSFT 5,926 Reputation points

2020-10-12T09:56:39.067+00:00

Hi @InderjeetKaur-3272 ,

Please redeploy the ssis packages into SSISDB Catalog.

Best Regards,
Mona
Nicky 121 Reputation points

2020-10-12T10:05:22.903+00:00

I am not able to redeploy the package.I get this error

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'microsoft.sqlserver.integrationservices.server, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A)
System.IO.FileLoadException:
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
Monalv-MSFT 5,926 Reputation points

2020-10-13T03:11:49.927+00:00

Hi @InderjeetKaur-3272 ,

Hope the following links will be helpful:

Could not load file or assembly 'microsoft.sqlserver.integrationservices.server

Deploying SSIS Package - 'Failed to load Assembly Microsoft.SqlServer.Management.IntegrationServicesEnum'

Best Regards,
Mona

Share via

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536

2 answers

Your answer