Windows error 0x8013150A, -2146233078

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

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

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

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

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

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

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

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

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

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

"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

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

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

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

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

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

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