Blog Stats
  • Posts - 7
  • Articles - 1
  • Comments - 38
  • Trackbacks - 2

 

Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

You know that song. Yes, that song. The beeping. The arm flailing. The Safety Dance. I so wanted it stay in the 80s – along side the uncounted Wild Turkey inflicted hangovers. It just won’t. Every now and then that damn beeping rhythm creeps into my conscious thought when I least need it to. Like today. I’ve been trying to figure out how to use the last-minute-added ability to catalog signed assemblies that need External Access or Unsafe permission without having to set the database trustworthy bit. Getting frustrated with the interesting example in Books Online, the beeping started.

So here’s what you really need to know:

  1. The first you need is a certificate that can establish a chain of trust to some trusted root certificate authority on the target machine. If you’ve already got one thanks to having Certificate Server on your network or you’ve purchased one, great. If not, you can make one for yourself as we’ll do there.
  2. You need to understand the *interesting* inter-play of certificates, logins and signing assemblies. It is not hard once you understand that you can use a single certificate to do all of that.
  3. You will have to comfortable using the Command Shell and a couple of tools in the .NET Software Development Kit (SDK), namely SignTool and MakeCert.

Continues here.


Feedback

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar Dancing gracefully is one way to unwind after a hard days of work. 1/21/2010 10:41 AM | hampers

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar This is a wonderful article, I like! You are welcome to read the following message:百度,[url=http://www.sina.com]sina[/url]. 3/23/2010 1:33 AM | BAIDU

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar welcome to golf equipment
and look forward to your best choice for golf-equipment. 4/10/2010 3:04 AM | golfequipment

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar thanks for sharing 4/23/2010 10:06 PM | highnfljerseys

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar wr961
Yes,I think so 4/29/2010 2:18 AM | massager

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar Nice .
Keep on . 6/6/2010 9:18 PM | air max tn

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar support it ! 11/23/2010 9:32 PM | fashion jewelry for women

# re: Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

Gravatar Should be quite good now. I did like that Safety Dance from the 80's...shame it's gone. 3/4/2011 6:05 AM | food hampers

# starter and alternator

Gravatar Very happy to see your article, I very much to like and agree with your point of view. Thank you for sharing. At the same time,i love Starter very much .Welcome to look at my website and blog articles. 5/25/2011 7:41 PM | wangxi

Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

 

 

Copyright © Kent Tegels