Server Does Note Exist error on SQL2000 OLEDB DTS Connection

Posted on 2007-09-29
Last Modified: 2013-11-30
I have SQL 2000 server personal edition installed on a Windows XP computer.  This is a development computer, so it has a lot of other software installed (VS 6.0, VS.Net, etc).  I am trying to edit an existsing DTS job which has an OLEDB connection to the server based on the server's name (same as the computer name).  The computer is on a LAN behind a simple Netgear firewall w/DHCP.  

When I attempt to open any of my existing DTS jobs through Ent Manager, all using the OLEDB connection object, I get the SQL Server Does not exist or access denied. error.  I am logged into the computer as the administrator. I tried creating a new DTS job and it opens fine, but when I try to create a connection object, it will only work if I use (local), not if I use the server name.  Interestingly, if I save that new package and try to re-open it in design view, I get the SQL Server Does not exist or access denied. error and can't get back into it.

There are no related entries in the SQL or event logs.  I AM able to work with the server fine through Query Analyzer or my VB app/ODBC connections.  This appears to be the only place I have the problem, but it is also the only place that I am relying on MS OLEDB and the server drop downs.

I have tried clearing my arp cache, renewing the IP address, adding a hosts entry assigning my computer's name to, reinstalling SQL server, reinstalling the tools, I checked my client network utility - TCP/IP is the only protocol enabled, same as it has always been.  As far as I know, nothing has changed but this previously worked.  I have installed/uninstalled some software as I have been working on other projects, but can't isolate what might be the problem.  This is getting critical.

I did read something from another user that their similar problem started when their ISP changed their outside IP address - who knows why it would cause a problem.  I'm sure my IP has changed, but they didn't have a solution and I don't know what to try.  Problem exists whether I am connected to my network or not.  I use Norton Int Sec, but have tried disabling the firewall, no diff.  Windows firewall is off.  HELP, PLEASE!
Question by:ehaley
    LVL 18

    Accepted Solution

    The question here is: Can you enter the current DTS to see what the setting is, and are you able to change it ? Or should something else be fixed so the old situation is restored and the package will work.
    The first option seems the best ans easiest to me, but you mentioned the DTS doesn't open ...

    did you also check you server network utility (svrnetcn.exe) for TCP/IP ?
    what does the SQL Server log tell you ?

    Hope this helps ...
    LVL 8

    Assisted Solution

    you must also enable named pipes. Try using the ip address. If it works with the ip address then, it means  the server name cannot be resolved. This could be some changes made on the network or domain controller. Try to remove the server from the domain then add it again.

    LVL 1

    Author Comment


    I never was able to get DTS to work - ended up having to do a backup on one server and restore on the other, then deal with the logins manually.  Thanks for the help guys.  I'll split the points as a thanks for the suggestions.
    LVL 1

    Author Closing Comment

    Good suggestions - useful to solve other problems I've had, just not this one.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how the fundamental information of how to create a table.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now