blocks|key|214632|text|我还不能评论，但请确保你完成了本指南中的所有检查：How+to+enable+remote+connections+in+SQL+Server+2008?如果完成了所有步骤，它应该会工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|214633|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx^0|P|1G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I can't comment yet, but make sure you made all the checks in this quide: <a href="http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx" rel="nofollow">How to enable remote connections in SQL Server 2008?</a> It should work fine if all steps are made.

blocks|key|214635|text|我刚刚遇到了同样的问题，并且能够通过安装Service+Pack+1来解决它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|214636|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=26727^0|K|E|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I just had the same issue and was able to solve it by installing <a href="http://www.microsoft.com/en-us/download/details.aspx?id=26727">Service Pack 1</a>.

blocks|key|212772|text|将SQL+Server升级到SP3|type|unstyled|depth|inlineStyleRanges|entityRanges|data|212773|可以从以下位置安装：http://www.microsoft.com/en-us/download/details.aspx?id=27594|offset|length|212774|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=27594^0|0|A|1P|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Upgrade your SQL Server to SP3

You can install it from:
<a href="http://www.microsoft.com/en-us/download/details.aspx?id=27594" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=27594</a>

blocks|key|2854998|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2854999|当.mof文件(管理对象格式)在安装过程中未正确安装和注册时，可能会出现此错误。为了解决这个问题，我在命令提示符下执行了以下mofcomp命令来重新注册*.mof文件：|blockquote|2855000|2855001|mofcomp.exe+"C:\Program+Files+(x86)\Microsoft+SQL+Server\100\Shared\sqlmgmproviderxpsp2up.mof“|2855002|2855003|This+one为我工作|offset|length|2855004|entityMap|0|LINK|mutability|MUTABLE|url|http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/569ee2d4-0805-40e2-a4f0-10f7d573fd75/^0|0|0|0|0|0|0|8|0|0^^$0|@$1|2|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|U|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|V|7|@]|8|@]|9|$]]|$1|E|3|F|4|5|6|W|7|@]|8|@]|9|$]]|$1|G|3|-4|4|5|6|X|7|@]|8|@]|9|$]]|$1|H|3|I|4|5|6|Y|7|@]|8|@$J|Z|K|10|1|11]]|9|$]]|$1|L|3|-4|4|5|6|12|7|@]|8|@]|9|$]]]|M|$N|$4|O|P|Q|9|$R|S]]]]

<blockquote>
 This error appears to happen when .mof files (Managed Object Format (MOF)) don’t get installed and registered correctly during set-up. To resolve this issue, I executed the following mofcomp command in command prompt to re-register the *.mof files:
 
 mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
</blockquote>

<a href="http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/569ee2d4-0805-40e2-a4f0-10f7d573fd75/" rel="nofollow">This one</a> worked for me

blocks|key|3068463|text|只有在我的工作计算机中安装了Microsoft+Visual+Studio+2012安装程序后，才会出现此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3068464|由于这是一个WMI错误，我重新编译了MOF文件->+mofcomp.exe+"C:\Program+Files+(x86)\Microsoft+SQL+Server\100\Shared\sqlmgmproviderxpsp2up.mof“|3068465|我还注销并重新注册了sql+provider+DLL+->+regsvr32+"C:\Program+Files+(x86)\Microsoft“，但问题没有解决。|3068466|解决方案：|offset|length|style|BOLD|3068467|我已经在我的SQL2008+R2实例上应用了SQL+Server2008+R2+SP2，这解决了SQL+Server配置管理器的问题。您可以从此处下载安装程序...http://www.microsoft.com/en-us/download/details.aspx?id=30437。|3068468|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=30437^0|0|0|0|0|5|0|2A|1P|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@$H|Z|I|10|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@]|9|@$H|12|I|13|1|14]]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

This error occurs only after I have installed the Microsoft Visual Studio 2012 setup in my work machine.

Since it is being a WMI error, I recompiled the MOF file –> mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

I also un-registered and re-registered the sql provider DLL –> regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll" but issue not resolved.

Solution:

I have applied SQL Server 2008 R2 SP2 on my SQL 2008 R2 instance and that fixed the issue with Sql Server Configuration Manager. You can download setup from here... <a href="http://www.microsoft.com/en-us/download/details.aspx?id=30437" rel="noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=30437</a> .

blocks|key|2855059|text|使用以下命令从命令提示符启动SQL+Server代理：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2855060|SQLAGENT90+-C+-V>C:\SQLAGENT.OUT|code-block|syntax|javascript|2855061|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

start SQL Server Agent from the command prompt using:

<pre><code>SQLAGENT90 -C -V&gt;C:\SQLAGENT.OUT
</code></pre>

blocks|key|2855097|text|打开控制面板>管理工具>服务>选择标准服务选项卡(在底部)>找到启动SQL+Server代理|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2855098|右键单击并选择属性，|2855099|启动类型:自动，|2855100|申请，好的。|2855101|好了。|2855102|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Open Control Panel > Administrative Tools > Services > Select Standard services tab (under the bottom) > Find start SQL Server Agent 

Right Click and select properties, 

Startup Type : Automatic,

Apply, Ok.

Done.

blocks|key|214733|text|您可能需要安装SQL+Server2008+SP3。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|214734|SQL+Server+2008+Service+Pack+3+|offset|length|214735|SQL+Server+2012+Configuration+Manager+WMI+Error+–+Remote+Procedure+call+failed+[0x800706be]|214736|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=27594|1|http://thesqldude.com/2012/12/05/sql-server-2012-configuration-manager-wmi-error-remote-procedure-call-failed-0x800706be/^0|0|0|V|0|0|0|2J|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

You might need to install SQL Server 2008 SP3.

<a href="http://www.microsoft.com/en-us/download/details.aspx?id=27594" rel="nofollow">SQL Server 2008 Service Pack 3 </a>

<a href="http://thesqldude.com/2012/12/05/sql-server-2012-configuration-manager-wmi-error-remote-procedure-call-failed-0x800706be/" rel="nofollow">SQL Server 2012 Configuration Manager WMI Error – Remote Procedure call failed [0x800706be]</a>

blocks|key|3068557|text|在尝试了Stackoverflow和谷歌之间的所有方法后，我终于找到了一个解决方案：http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3068558|TL;DR+:|style|BOLD|3068559|如果您计算机上正在(或曾经)运行多个版本的SQL+Server，则“开始”菜单上的“配置管理器”快捷方式可能指向不应该指向的较旧版本。在我的例子中，它指向一个旧的Sql+Server2008实例。|3068560|解决方案是：|3068561|3068562|根据您的系统，转到C:\Windows\SysWOW64或C:\Windows\System32。|ordered-list-item|3068563|查找名为SQLServerManagerXX.msc的可执行文件，如果有多个可执行文件，则运行最新版本。在我的例子中，我有SQLServerManager11.msc和SQLServerManager10.msc，其中第10个给出了错误，而第11个工作得很好。|3068564|3068565|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed/^0|16|2D|0|0|0|7|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@$A|15|B|16|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|18|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|19|8|@]|9|@]|C|$]]|$1|M|3|N|5|O|7|1A|8|@]|9|@]|C|$]]|$1|P|3|Q|5|O|7|1B|8|@]|9|@]|C|$]]|$1|R|3|-4|5|6|7|1C|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

After trying everything between Stackoverflow and Google, I finally found a solution : <a href="http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed/" rel="noreferrer">http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/remote-procedure-call-failed/</a>

TL;DR :

If you are (or were) running multiple versions of SQL Server on your machine, that Configuration Manager shortcut on your start menu might be pointing to an older version, which it shouldn't be. It was pointing to an old Sql Server 2008 instance in my case.

The solution was to :

<ol>
<li>Go to either C:\Windows\SysWOW64 or C:\Windows\System32, depending on your system.</li>
<li>Look for an executable called SQLServerManagerXX.msc, and run the latest version if you have multiple ones. In my case, I had both SQLServerManager11.msc and SQLServerManager10.msc, where the 10th gave the error, and the 11th worked perfectly.</li>
</ol>

blocks|key|2855151|text|当SQLServer和SQLServerAgent服务都在运行时，我遇到了类似的问题。通过重新启动服务来修复该错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2855152|Server+Manager+>+Service+>+
++++SQL+Server+>+Stop
++++SQL+Server+>+Start
++++SQL+Server+Agent+>+Start|code-block|syntax|javascript|2855153|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I got the samilar issue, while both SQLServer and SQLServerAgent services are running. The error is fixed by a restart of services. 

<pre><code>Server Manager &gt; Service &gt; 
 SQL Server &gt; Stop
 SQL Server &gt; Start
 SQL Server Agent &gt; Start
</code></pre>

blocks|key|2855167|text|打开控制面板管理工具服务选择扩展服务选项卡|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2855168|查找SQL+Server(MSSQLSERVER)和SQL+Server(SQLEXPRESS)停止这些服务，然后重新启动(从上面显示的Start+&+Stop按钮)|2855169|好了。|2855170|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Open Control Panel
Administrative Tools
Services
Select Extended services tab
Find SQL Server(MSSQLSERVER) &amp; SQL Server(SQLEXPRESS)
Stop these services and Start again (from the start &amp; stop button displayed above)
Done.

I am working with SQL Server 2008 R2. I am unable to connect to my database remotely. I got the following error.

<blockquote>
 A network-related or instance-specific error occurred while establishing a connection 
 to SQL Server. The server was not found or was not accessible. Verify that the instance 
 name is correct and that SQL Server is configured to allow remote connections. 
 (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
</blockquote>

I have checked the SQL Server properties and I enable the Allow remote connections.

I have checked the Service manager and SQL Server service are running.

I have checked the configuration manager, I can't see any services under SQL Server Services
and it shows Remote Procedure call failed 

<img src="https://i.stack.imgur.com/wuet1.png" alt="enter image description here">

So please guide me.

Remote Procedure call failed with sql server 2008 R2

Visual Studio

SQL Server

数据库

服务器

Windows

我正在使用SQL Server2008 R2。我无法远程连接到数据库。我得到了以下错误。建立与SQL Server的连接时发生与网络有关的错误或特定于实例的错误。服务器找不到或无法访问。请验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。(提供程序:命名管道提供程序，错误: 40 -无法打开与SQL...

问使用sql server 2008 R2进行远程过程调用失败。
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用sql server 2008 R2进行远程过程调用失败。EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用sql server 2008 R2进行远程过程调用失败。
EN