Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for...
My cat mixes up the floors in my building. How can I help him?
Roman Numerals equation 1
Incorporating research and background: How much is too much?
Avoiding morning and evening handshakes
Early credit roll before the end of the film
What are "industrial chops"?
Why do members of Congress in committee hearings ask witnesses the same question multiple times?
Are there any modern advantages of a fire piston?
Advice for a new journal editor
Porting Linux to another platform requirements
Strange Sign on Lab Door
How can I deliver in-universe written lore to players without it being dry exposition?
Would a National Army of mercenaries be a feasible idea?
One Half of Ten; A Riddle
What is 6÷2×(1+2) =?
Table formatting top left corner caption
Can I write a book of my D&D game?
How to avoid being sexist when trying to employ someone to function in a very sexist environment?
Injecting creativity into a cookbook
How long is the D&D Starter Set campaign?
How to solve a large system of linear algebra?
Traveling through the asteriod belt?
Intern applicant asking for compensation equivalent to that of permanent employee
Could a phylactery of a lich be a mirror or does it have to be a box?
Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for microsoft.sqlserver.integrationservices.server
Error creating database in SQL Server Management Studio. (Could not load file or assembly 'Microsoft.SqlServer.Sqm)Assembly 'system.web, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalogError while executing SSIS package which contains Script component through SQL Server Agent JobSQL Server installation errors assembly.NET SQLCLR Assembly not working in SQL Server 2016 (Error msg 10314)Assembly 'EDCLR' references assembly 'system.servicemodel, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 errorSQL Server CLR 'Failed to create AppDomain' debuggingError Msg 10314, Level 16, State 11 with SAFE assembly after upgrade to SQL Server 2017Error occur during Oracle and Sql Server IntegrationSQL Server Agent Services not Coming Up
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♦ 7 mins 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♦ 7 mins 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♦ 7 mins 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♦ 7 mins 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