













From machine B, I can use SSMS to connect to SQL Server on machine A. This is using either "New Query" or "Object Explorer".
However, on machine A, SSMS can only connect to machines A or B using the "New Query" option. If I try "Object Explorer" for either, I get the error message "Failed to retrieve data for this request... urn could not be resolved at level Configuration."
I'm not sure what died (no pun intended) since the last time this worked. Any thoughts on this?
ANSWER:
The same was happening to me without making changes on my PC or my SQL server environment.
ERROR window:
Connect to Server
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
urn could not be resolved at level Configuration. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476"
RESOLUTION was:
1. Open c:\Program Files\Microsoft SQL Server\90\dts\Binn\MsDtsSrvr.ini.xml
2. Modify the ServerName line to read "(local)" or a more specific server name instead of a "."
3. Restart SQL Server service
SAMPLE:
总结
最终还是没按上述方法解决,只是先连接下本地数据库,能打开。然后再连接非本机数据库,就可以了。
网上这个错误好像很少。
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。