在級別Configuration 上無法解析urn 錯誤

原因
估計是昨天連接時，用的本機數據庫，使用.作為本機數據源。如：
<add name="StrCon" connectionString="Data Source=.; Initial Catalog=MYPPA; Integrated Security=SSPI;"/>

解決
網上找到解決方法 http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/17b68347-9e29-4b5c-9358-0f039d4ce0ea/
如下：

QUESTION:
I've installed SQL Server 2005 SP1 RTM on a Windows 2003 R2 machine (machine A), and my local workstation (machine B).

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 FilesMicrosoft SQL Server90dtsBinnMsDtsSrvr.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:

Code Snippet
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchemahttp://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</A< A>>" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
'>http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance">
; <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>(local)</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

Good luck!

總結
最終還是沒按上述方法解決，只是先連接下本地數據庫，能打開。然后再連接非本機數據庫，就可以了。
網上這個錯誤好像很少。

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈