Windows error 0x8013150A, -2146233078

Detailed Error Information

COR_E_SECURITY[1]

Message"An error relating to security occurred."
Comment An error relating to security occurred.

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode19 (0x013)
NameFACILITY_URT[2][3]
DescriptionThe source of the error code is .NET CLR.[2][3]
Error Code5386 (0x150a)

Questions

35votes
5answers

FileLoadException / Msg 10314 Error Running CLR Stored Procedure

Receiving the following error when attempting to run a CLR stored proc. Any help is much appreciated. Msg 10314, Level 16, State 11, Line 1 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65752. The server may be running out of resources, or the [...] read more
sql-server
sqlclr
7votes
2answers

Changing database owner in SQL Server 2008; CLR issues depending on method used?

I attached a database and tried changing the owner to a valid login. I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa". The database properties showed that the new owner was 'sa', however I was still getting permission errors for unrestricted CLR assemblies (0x80FC80F1, 0x8013150A), something about assembly trust [...] read more
sql-server
security
database-administration
permissions
4votes
1answer

Assembly.LoadFrom() permissioning in .NET 4.0

I am having trouble with security while migrating an application from .NET 3.5 to 4.0. I have an application that starts successfully from a network share I've mapped to z: - Z:\MyApp\App.exe. This application makes use of add-ins, and is sometimes asked to load assemblies from a seperate location on [...] read more
c#
.net
visual-studio-2010
3votes
1answer

IN SSISDB not able to create new folder

While I'm creating a folder in Integration service catalog - SSISDB i'm getting an error as below, TITLE: Microsoft SQL Server Management Studio ------------------------------ Operation 'Create' on object 'CatalogFolder[@Name='dev']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. [...] read more
ssis
sql-server-2012
2votes
1answer

Is it possible to find out the original path that was used to load the assembly in SQL SERVER CLR?

I am very new to working with Assemblies CLR in SQL Server I have a database that has many of them enter image description here [https://i.stack.imgur.com/T9wOg.png] Is it possible to find out the original path that was used to load the assembly ? Considering this is the way the assemblies [...] read more
sql
sql-server
sqlclr
2votes
2answers

Make assembly from SQL 2016 work in SQL 2017 (ex: Calling Math Parser from SQL Server 2017)

I have a stored procedure that needs some complex math expression evaluation. There is a formula and this stored procedure evaluates its value. It calls an UDF defined as below: ALTER FUNCTION [dbo].[udfComputeMath] (@inputString [NVARCHAR](MAX)) RETURNS [NVARCHAR](4000) WITH EXECUTE AS CALLER AS EXTERNAL NAME [SMP_Assembly].[SuperMathParser.MathParser].[ComputeMath] This is quite old code, [...] read more
sql-server
sql-server-2017
1vote
1answer

Issue Deploying SSIS Package

I am working at a small company with no DBA but we use SQL Server for reporting. I'd like to get SSIS up and running for some ETL and back end processes. I used to develop in the past so have some basic skills but no DBA experience at all. [...] read more
sql-server
deployment
ssis
1vote
2answers

My SQL Server 2008 R2 CLR works sometimes, but not others, but why?

I have a CLR DLL (called clr.dll) which we've previously loaded and used. I'm using it to load a large number of XML files (for which we have no XSD so we can't use the fiddly XML processor in SSIS as this requires an XSD). I'm loading it into a [...] read more
sql-server
security
sql-server-2008-r2
sqlclr
1vote
1answer

TSQL CREATE ASSEMBLY FROM varbinary breaks the class_name parameter

I have migrated my on-premise SQL Server 2008 R2 databases to Azure SQL Server Managed Instance (SQL Server 2017). One database is an archive (read-only) database, one is the OLTP database, and the third is an utility database, where I keep generic functions, stored procedures, and maintenance scripts. Everything went [...] read more
.net
sql-server
.net-assembly
sqlclr
azure-sql-managed-instance
1vote
2answers

What are specific steps to install signed CLR storedproc to SQL?

This has been dogging me for 2 days now. I have a CLR sp that needs EXTERNAL_ACCESS. I can deploy it via VS2010 on my dev box by setting TRUSTWORTHY ON but we don't want to do that to the production server. We purchased an AuthentiCode compatible cert and I [...] read more
sql-server
sqlclr
code-signing-certificate
1vote
1answer

Getting error on executing CLR procedure in sql server

I am using the microsoft sql server 2008. On executing the CLR procedure i am getting the below error. > An error occurred in the Microsoft .NET Framework while trying to load > assembly id 65547. The server may be running out of resources, or the assembly > may not [...] read more
sql-server
.net-assembly
clrstoredprocedure
1vote
1answer

"Generic SQL Error "when attempting to execute a FetchXml query

I have a website that is using the XRM SDK to query CRM. For the most part I'm using Query Expressions, but I'm doing an aggregate count on one page, and hence, I'm using a Fetch XML query. I've debugged the website on my local developer machine, pointing to the [...] read more
c#
.net
sql-server-2008
dynamics-crm-2011
0votes
0answers

Dynamics 365 Plugin : How to call a web request

Hello everyone my name is Taniguchi. I trying to retrieve information from itb360 database using a get request consuming an url but in the plugin when i try to get the response its shows me an error but i used the same code in console application and worked just fine [...] read more
c#
c#-4.0
dynamic
plugins
httpwebrequest
0votes
0answers

Job execution error after upgrading from SQL Server 2016 to SQL Server 2019

We have our database in SQL Server 2016 and we restored the same database, packages and jobs in new SQL Server 2019 server instance. We changed the environment variables to point to new server and also pointed new package path in the jobs. While running the job we are getting [...] read more
ssis
sql-server-2016
sql-server-2019
ssis-2016
ssis-2019
0votes
1answer

Exception while debugging using windows MAF (AddIn pipeline)

I have been trying to build a AddIn architecture and was using the MAF. The basics that I have followed are given here on Microsoft docs Brief background about the application: 1. I have a wpf host application, which will load the addIn assembly at runtime. The addIns implement a [...] read more
c#
wpf
add-in
maf
0votes
0answers

sp_db_sendmail error

I am currently running SQL Server 2014 and trying to execute a stored procedure that sends out an email using sp_db_sendmail which is failing with the following error. > An error occurred in the Microsoft .NET Framework while trying to load > assembly id 65549. The server may be running [...] read more
tsql
sql-server-2014
sp-send-dbmail
0votes
1answer

Formview options disappear in code behind Visual Studio 2010

I have several .aspx Web sites created with Visual Studio 2010. I recently updated them from .net3.5 framework to .net4.0. I installed NuGet Package Manager to install the app_browsersUpdate package so the sites would work properly in IE10. Web sites connect to various internal SQL databases. Since the update (I [...] read more
asp.net
vb.net
visual-studio-2010
0votes
2answers

Error calling Stored Procedure which executes a .net assembly

I'm getting the following error when trying to execute a stored procedure which calls a .net assembly deployed within a SQL 2005 database: Msg 50000, Level 16, State 1, Procedure usp_GetPrintFilePathandExecPrintJob, Line 63 Error (10314) has occured while executing the usp_GetPrintFilePathandExecPrintJob method. Reason: An error occurred in the Microsoft .NET [...] read more
.net
sql-server

Comments

Leave a comment

(plain text only)

Sources

  1. https://github.com/dotnet/coreclr/blob/v1.1.0/src/inc/corerror.xml
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx
  3. winerror.h from Windows SDK 10.0.14393.0

User contributions licensed under CC BY-SA 3.0