Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for...
I am running SSIS Packages through an Agent job and getting error 0x80131904:
Message:
Executed as user: NT ServiceSQLSERVERAGENT.
Microsoft (R) SQL Server Execute Package Utility
Version 14.0.3023.8 for 64-bit
Copyright (C) 2017 Microsoft. All rights reserved.
Started: 1:00:00 PM
Failed to execute IS server package because of error 0x80131904. Description:
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=12.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)
Source: .Net SqlClient Data Provider
Started: 1:00:00 PM
Finished: 1:00:00 PM
Elapsed: 0.328 seconds.
The package execution failed.
The step failed.
I researched and found that I should enable CLR and set TRUSTWORTHY to ON for the DB. I did that and in addition checked the database owner account; it's enabled and not orphaned. Still getting the error. I would highly appreciate any help on this.
sql-server azure-sql-database sql-server-2017 sql-clr
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am running SSIS Packages through an Agent job and getting error 0x80131904:
Message:
Executed as user: NT ServiceSQLSERVERAGENT.
Microsoft (R) SQL Server Execute Package Utility
Version 14.0.3023.8 for 64-bit
Copyright (C) 2017 Microsoft. All rights reserved.
Started: 1:00:00 PM
Failed to execute IS server package because of error 0x80131904. Description:
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=12.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)
Source: .Net SqlClient Data Provider
Started: 1:00:00 PM
Finished: 1:00:00 PM
Elapsed: 0.328 seconds.
The package execution failed.
The step failed.
I researched and found that I should enable CLR and set TRUSTWORTHY to ON for the DB. I did that and in addition checked the database owner account; it's enabled and not orphaned. Still getting the error. I would highly appreciate any help on this.
sql-server azure-sql-database sql-server-2017 sql-clr
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiringEXTERNAL_ACCESSorUNSAFE? If so, is thePERMISSION_SETof the Assembly set to eitherEXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not"context connection=true")?
– Solomon Rutzky
Sep 8 '18 at 13:56
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB toTRUSTWORTHY ONand change the owner of that DB? The error you are getting, which is really0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set toEXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?
– Solomon Rutzky
Sep 10 '18 at 19:24
add a comment |
I am running SSIS Packages through an Agent job and getting error 0x80131904:
Message:
Executed as user: NT ServiceSQLSERVERAGENT.
Microsoft (R) SQL Server Execute Package Utility
Version 14.0.3023.8 for 64-bit
Copyright (C) 2017 Microsoft. All rights reserved.
Started: 1:00:00 PM
Failed to execute IS server package because of error 0x80131904. Description:
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=12.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)
Source: .Net SqlClient Data Provider
Started: 1:00:00 PM
Finished: 1:00:00 PM
Elapsed: 0.328 seconds.
The package execution failed.
The step failed.
I researched and found that I should enable CLR and set TRUSTWORTHY to ON for the DB. I did that and in addition checked the database owner account; it's enabled and not orphaned. Still getting the error. I would highly appreciate any help on this.
sql-server azure-sql-database sql-server-2017 sql-clr
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
I am running SSIS Packages through an Agent job and getting error 0x80131904:
Message:
Executed as user: NT ServiceSQLSERVERAGENT.
Microsoft (R) SQL Server Execute Package Utility
Version 14.0.3023.8 for 64-bit
Copyright (C) 2017 Microsoft. All rights reserved.
Started: 1:00:00 PM
Failed to execute IS server package because of error 0x80131904. Description:
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=12.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)
Source: .Net SqlClient Data Provider
Started: 1:00:00 PM
Finished: 1:00:00 PM
Elapsed: 0.328 seconds.
The package execution failed.
The step failed.
I researched and found that I should enable CLR and set TRUSTWORTHY to ON for the DB. I did that and in addition checked the database owner account; it's enabled and not orphaned. Still getting the error. I would highly appreciate any help on this.
sql-server azure-sql-database sql-server-2017 sql-clr
sql-server azure-sql-database sql-server-2017 sql-clr
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
edited Sep 10 '18 at 19:14
Solomon Rutzky
48.8k581177
48.8k581177
asked Sep 7 '18 at 16:49
user160248user160248
1
asked Sep 7 '18 at 16:49
user160248user160248
1
asked Sep 7 '18 at 16:49
user160248user160248
1
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiringEXTERNAL_ACCESSorUNSAFE? If so, is thePERMISSION_SETof the Assembly set to eitherEXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not"context connection=true")?
– Solomon Rutzky
Sep 8 '18 at 13:56
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB toTRUSTWORTHY ONand change the owner of that DB? The error you are getting, which is really0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set toEXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?
– Solomon Rutzky
Sep 10 '18 at 19:24
add a comment |
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiringEXTERNAL_ACCESSorUNSAFE? If so, is thePERMISSION_SETof the Assembly set to eitherEXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not"context connection=true")?
– Solomon Rutzky
Sep 8 '18 at 13:56
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB toTRUSTWORTHY ONand change the owner of that DB? The error you are getting, which is really0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set toEXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?
– Solomon Rutzky
Sep 10 '18 at 19:24
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiring
EXTERNAL_ACCESS or UNSAFE? If so, is the PERMISSION_SET of the Assembly set to either EXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not "context connection=true")?– Solomon Rutzky
Sep 8 '18 at 13:56
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiring
EXTERNAL_ACCESS or UNSAFE? If so, is the PERMISSION_SET of the Assembly set to either EXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not "context connection=true")?– Solomon Rutzky
Sep 8 '18 at 13:56
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB to
TRUSTWORTHY ON and change the owner of that DB? The error you are getting, which is really 0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set to EXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?– Solomon Rutzky
Sep 10 '18 at 19:24
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB to
TRUSTWORTHY ON and change the owner of that DB? The error you are getting, which is really 0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set to EXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?– Solomon Rutzky
Sep 10 '18 at 19:24
add a comment |
2 Answers
2
active
oldest
votes
Have you tried this:
USE <DATABASE>;
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
First Enable Trustworthy database property
ALTER DATABASE [DatabaseName] SET TRUSTWORTHY ON;
GO
And change the database owner to ‘sa’
USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
answered Sep 7 '18 at 18:19
CR241CR241
781319
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
add a comment |
Message:
Executed as user: NT ServiceSQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 1:00:00 PM Failed to execute IS server package because of error 0x80131904. Description: 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=12.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) Source: .Net SqlClient Data Provider Started: 1:00:00 PM Finished: 1:00:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f217038%2ferror-0x80131904-failed-to-load-assembly-id-65536-hresult-0x8013150a-for-micr%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Have you tried this:
USE <DATABASE>;
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
First Enable Trustworthy database property
ALTER DATABASE [DatabaseName] SET TRUSTWORTHY ON;
GO
And change the database owner to ‘sa’
USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
answered Sep 7 '18 at 18:19
CR241CR241
781319
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
add a comment |
Have you tried this:
USE <DATABASE>;
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
First Enable Trustworthy database property
ALTER DATABASE [DatabaseName] SET TRUSTWORTHY ON;
GO
And change the database owner to ‘sa’
USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
answered Sep 7 '18 at 18:19
CR241CR241
781319
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
add a comment |
Have you tried this:
USE <DATABASE>;
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
First Enable Trustworthy database property
ALTER DATABASE [DatabaseName] SET TRUSTWORTHY ON;
GO
And change the database owner to ‘sa’
USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
answered Sep 7 '18 at 18:19
CR241CR241
781319
Have you tried this:
USE <DATABASE>;
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
First Enable Trustworthy database property
ALTER DATABASE [DatabaseName] SET TRUSTWORTHY ON;
GO
And change the database owner to ‘sa’
USE [DatabaseName]
GO
EXEC sp_changedbowner 'sa'
GO
answered Sep 7 '18 at 18:19
CR241CR241
781319
edited Sep 7 '18 at 19:19
answered Sep 7 '18 at 18:19
CR241CR241
781319
answered Sep 7 '18 at 18:19
CR241CR241
781319
answered Sep 7 '18 at 18:19
CR241CR241
781319
781319
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
add a comment |
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
Yes I have tried these all three steps, enabling CLR, setting trustworthy on and changing the db owner to sa.
– Iftekhar Ilm
Sep 7 '18 at 21:54
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
@IftekharIlm If you are the same person who asked the question, please see about getting your accounts merged. Then, you should be able to comment on your own question, as well as answers to the question.
– RDFozz
Sep 7 '18 at 23:17
add a comment |
Message:
Executed as user: NT ServiceSQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 1:00:00 PM Failed to execute IS server package because of error 0x80131904. Description: 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=12.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) Source: .Net SqlClient Data Provider Started: 1:00:00 PM Finished: 1:00:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
add a comment |
Message:
Executed as user: NT ServiceSQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 1:00:00 PM Failed to execute IS server package because of error 0x80131904. Description: 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=12.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) Source: .Net SqlClient Data Provider Started: 1:00:00 PM Finished: 1:00:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
add a comment |
Message:
Executed as user: NT ServiceSQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 1:00:00 PM Failed to execute IS server package because of error 0x80131904. Description: 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=12.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) Source: .Net SqlClient Data Provider Started: 1:00:00 PM Finished: 1:00:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
Message:
Executed as user: NT ServiceSQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 1:00:00 PM Failed to execute IS server package because of error 0x80131904. Description: 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=12.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) Source: .Net SqlClient Data Provider Started: 1:00:00 PM Finished: 1:00:00 PM Elapsed: 0.328 seconds. The package execution failed. The step failed.
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
edited Sep 10 '18 at 14:41
RDFozz
9,90231531
9,90231531
answered Sep 10 '18 at 8:51
user160248user160248
1
answered Sep 10 '18 at 8:51
user160248user160248
1
answered Sep 10 '18 at 8:51
user160248user160248
1
1
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
add a comment |
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
Hi there. I have edited the question to add this content. Please delete this answer. In the future, you can just update the question with new info or changes. You don't need to add comments below the question. Thanks :)
– Solomon Rutzky
Sep 10 '18 at 19:15
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f217038%2ferror-0x80131904-failed-to-load-assembly-id-65536-hresult-0x8013150a-for-micr%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why did you mark this azure sql database and sql server 2017?
– Anthony Genovese
Sep 7 '18 at 17:40
Is there any more text to the error message besides the error #? Please post the entire error message. Also, what is the SQLCLR method doing? Anything requiring
EXTERNAL_ACCESSorUNSAFE? If so, is thePERMISSION_SETof the Assembly set to eitherEXTERNAL_ACCESS? From what I am seeing, "0x80131904" indicates an error when trying to connect to SQL Server. Does your SQLCLR method use SqlClient to connect to SQL Server using a regular / external connection (i.e. not"context connection=true")?– Solomon Rutzky
Sep 8 '18 at 13:56
Thanks @Solomon I have posted the complete message in the Answer section as I was not able to post here. Please find it below in this thread.
– user160248
Sep 10 '18 at 8:49
@user160248 Hi there. You don't need to add comments or answers in order to provide more info. You can (and should) simply edit the question and add / change whatever. What DB is the Assembly loaded into? Did you set that DB to
TRUSTWORTHY ONand change the owner of that DB? The error you are getting, which is really0x8013150A, has been corrected in all cases that I could find by those 2 actions. Also, did you check the PERMISSION_SET for the assembly? It should be set toEXTERNAL_ACCESS. Can you execute this same package using DTExec.exe at a command prompt?– Solomon Rutzky
Sep 10 '18 at 19:24