Problem
Today, when SQL Server Management studio of sqlserver2005 is opened to connect to a non-local database, an error is displayed:
"Failed to parse urn on level Configuration"
Cause
It is estimated that the local database was used during the connection yesterday, And the. Data source was used as the local data source. For example:
<Add name = "strcon" connectionstring = "Data Source =.; initial catalog = myppa; Integrated Security = sspi;"/>
Solution
Find solution http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/17b68347-9e29-4b5c-9358-0f039d4ce0ea/ online
As follows:
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 cocould 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 & link id = 20476
Urn cocould 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 "."
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!
Summary
In the end, the solution was not solved as described above, but the local database was first connected and enabled. Then you can connect to a non-local database.
This error appears to be rare on the Internet.