Failed to parse the urn error on level Configuration

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

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.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.