Using .NET Framework 3.5 in a SQL Server 2005 Stored Procedure

Question

I have an SQL Server 2005 server, and I'd like to run a .Net CLR stored procedure on it. However, I'd like to use .NET Framework 3.5.

If I try this right now, I get this error:

Error: Assembly 'system.core, version=3.5.0.0, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.

I'm told this is possible in SQL Server 2008, because SQL Server 2008 ships with .NET Framework 3.5. However, I'm wondering if there's a way to add .NET Framework 3.5 to my SQL Server 2005 installation, so that I can run .NET 3.5 stored procedures on it.

James Orr · Accepted Answer · 2008-12-02 21:34:54Z

4

This might be a stupid question but... If system.core can't be found, do you have the framework 3.5 installed on the database server?

answered Dec 2, 2008 at 21:34

James Orr

5,1557 gold badges44 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

codes_occasionally Over a year ago

Well, I don't actually have access to check...I figured I'd ask before putting in a request. Is it really just as simple as installing the .net 3.5 runtime?

HTTP 410 Over a year ago

That would be a minimum requirement. How did you expect it to work if 3.5 wasn't installed?

Scott Weinstein · Accepted Answer · 2009-08-24 18:37:42Z

2

The result of google + trial & error

EXEC dbo.sp_changedbowner @loginame = N'sa', @map = true
GO
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
ALTER DATABASE [MyDB] SET TRUSTWORTHY ON
GO
CREATE ASSEMBLY [System.Core]
AUTHORIZATION [dbo]
FROM 
'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll'
WITH PERMISSION_SET = UNSAFE
GO

Sites:

answered Aug 24, 2009 at 18:37

Scott Weinstein

19.1k15 gold badges83 silver badges117 bronze badges

1 Comment

uzay95 Over a year ago

ALTER DATABASE [MyDB] SET TRUSTWORTHY ON There is no need to use this line and also it may cause security issues.

HTTP 410 · Accepted Answer · 2008-12-03 00:32:38Z

1

This thread might be helpful to you.

answered Dec 3, 2008 at 0:32

HTTP 410

17.7k14 gold badges80 silver badges130 bronze badges

Collectives™ on Stack Overflow

Using .NET Framework 3.5 in a SQL Server 2005 Stored Procedure

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related