title: Could not load file or assembly Microsoft.SqlServer.SqlClrProvider on production ASP.net site, where is it?
body: <p>On my ASP.net site I have a reference to <code>Microsoft.SQLserver.SMO</code>. I copied this reference onto my production server and got a could not load error for <code>Microsoft.SqlServer.Management.Sdk.Sfc</code>. This error was fixed by copying the dll from the </p>
  
  <pre><code>C:\Program files\Microsoft Sql Server\110\SDK\Assembilies
  </code></pre>
  
  <p>However I then got the same error but for <code>Microsoft.SqlServer.SqlClrProvider</code> which is nowhere to be found. </p>
  
  <p>Where can I find the <code>SqlClrProvider</code> dll? It works on my localhost so it must be somewhere.</p>