blocks|key|4651046|text|使用Microsoft.Sqlerver.SMO+reference时，我无法解决我的问题。所以我转而使用System.Data.Sql.SqlDataSourceEnumerator类来满足我的所有Sql功能需求。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4651047|entityMap^0|2|M|1H|13|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

I could not solve my issue, while using <code>Microsoft.Sqlerver.SMO</code> reference. So I instead used the <code>System.Data.Sql.SqlDataSourceEnumerator</code> class for all my Sql functionality needs.

blocks|key|144455|text|我想在powershell中创建一个嵌入式脚本，然后偶然发现您遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|144456|问题是Microsoft.SqlServer.SqlClrProvider.dll不是安装在SQL文件中，而是安装在windows+assembly中。|offset|length|style|CODE|144457|Assembly文件夹是特殊的:你不能用windows+UI复制任何东西。|144458|我只需要Microsoft.SqlServer.SqlClrProvider.dll，这样我就可以像这样将它加载到我的脚本中：|144459|[System.Reflection.Assembly]::LoadFile($scriptPath%2B"dll\Microsoft.SqlServer.SqlClrProvider.dll")+%7C+out-null|code-block|syntax|javascript|144460|要复制它，您可以执行以下操作：|144461|c:\>cd+c:\Windows\assembly
c:\Windows\assembly>dir+/s+Microsoft.SqlServer.SqlClrProvider.dll
#+here+you+get+the+directory+and+the+file
c:\Windows\assembly>copy+c:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlClrProvider\<version>\Microsoft.SqlServer.SqlClrProvider.dll+c:\Users\Administrator\Desktop\|144462|您希望在安装了SQLserver的计算机上执行此操作，否则您可能找不到它。|144463|这只是一种变通方法。如果你需要在不同的环境中执行你的脚本，我想这不是最好的做法。|144464|hth|144465|entityMap^0|0|3|12|1U|8|0|0|8|0|4|12|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@$D|14|E|15|F|G]|$D|16|E|17|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|18|8|@$D|19|E|1A|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1B|8|@$D|1C|E|1D|F|G]]|9|@]|A|$]]|$1|L|3|M|5|N|7|1E|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|1G|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|11|$]]

I wanted to make an embedded script in powershell and stumble upon your same problem.

The thing is that <code>Microsoft.SqlServer.SqlClrProvider.dll</code> is not installed in SQL files but in windows <code>assembly</code>.

<code>Assembly</code> folder is special: you can't copy anything with windows UI.

I just needed the <code>Microsoft.SqlServer.SqlClrProvider.dll</code> so that I can load it in my script like that:

<pre><code>[System.Reflection.Assembly]::LoadFile($scriptPath+"dll\Microsoft.SqlServer.SqlClrProvider.dll") | out-null
</code></pre>

to copy it you can do the following:

<pre><code>c:\&gt;cd c:\Windows\assembly
c:\Windows\assembly&gt;dir /s Microsoft.SqlServer.SqlClrProvider.dll
# here you get the directory and the file
c:\Windows\assembly&gt;copy c:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlClrProvider\&lt;version&gt;\Microsoft.SqlServer.SqlClrProvider.dll c:\Users\Administrator\Desktop\
</code></pre>

you want to do that on a machine with SQLserver installed otherwise you may not find it.

It's just a workaround. I guess it's not the best thing to do if you need to execute your script in different environments.

hth

blocks|key|4651154|text|对于用谷歌搜索这个错误并到达这里的人来说，还有另一种可能性。进入“服务”，并确保您的SQL+Server进程可以运行。在我的机器上，用户帐户的密码已经更改。一旦我修复了密码，进程就开始了，并且我不再收到上面的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651155|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For people googling this error, and arriving here, there is another possibility. Go into Services, and make sure that your SQL Server process can run. On my machine, the password for the user account had changed. Once I fixed the password, the process started, and I no longer received the above error.

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 

<pre><code>C:\Program files\Microsoft Sql Server\110\SDK\Assembilies
</code></pre>

However I then got the same error but for <code>Microsoft.SqlServer.SqlClrProvider</code> which is nowhere to be found. 

Where can I find the <code>SqlClrProvider</code> dll? It works on my localhost so it must be somewhere.

Could not load file or assembly Microsoft.SqlServer.SqlClrProvider on production ASP.net site, where is it?

SQL Server

服务器

Windows

在我的ASP.net站点上，我有一个对Microsoft.SQLserver.SMO的引用。我将此引用复制到我的生产服务器上，并收到Microsoft.SqlServer.Management.Sdk.Sfc的copied load错误。通过将dll从C:\Program files\Microsoft Sql Ser...

问无法在生产ASP.net站点上加载文件或程序集Microsoft.SqlServer.SqlClrProvider，它在哪里？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在生产ASP.net站点上加载文件或程序集Microsoft.SqlServer.SqlClrProvider，它在哪里？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在生产ASP.net站点上加载文件或程序集Microsoft.SqlServer.SqlClrProvider，它在哪里？
EN