Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This is in a development system which is why i have a self generated SSL certificate. Its setup on our dev exchange server; i need to add a trust to call it from a CLR running inside SQL Server. Have downloaded teh certificate from IE but cant work out which certificate store to save it in; can anyone let me know.

The windows is windows 2003, doubt it matters but its exchange 2007.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

You should install the certificate in the Trusted Root store for the security context (user) that will be executing the CLR code that makes the connection. This would be the SQL Server service account unless you are using impersonation.

For more info on CLR impersonation, check out this post from the SQL CLR Integration Team at Microsoft: http://blogs.msdn.com/sqlclr/archive/2006/06/16/635003.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.