[DBNMPNTW]Specified SQL server not found.

Posted on 2004-11-18
Last Modified: 2007-12-19

I'm developing an ASP page to connect to a remote SQL server but i'm having a few problems.  I have create the page successfully and it connects and does all it should from my machine, however when i move the script onto another webserver (where it is to eventually reside) I get presented with the following error

[DBNMPNTW]Specified SQL server not found.

Any ideas why this would working on my local machine but not the webserver?

Many Thanks

Question by:Memorix
    LVL 14

    Expert Comment

    The second server can not connect to the SQL server of interest.
    Some possible solutions gathered from the web:

    Use the SQL Client Configuration utility (from the machine u are connecting)
    to create alias server name for the sql server using the TCP/IP protocol
    specifying IP and port number.
    And use this Alias name to connect to SQL server using TCP/IP

    Wish I can help
    LVL 3

    Author Comment


    Thanks for your response.  I had previously tried the method you described above without any luck, however after reading another article about this issue it came to light that an incorrect version of the MDAC could also cause the same symptoms so we upgraded MDAC to 2.8 and hey presto... success

    Many thanks for trying to help though
    LVL 14

    Expert Comment

    No! Not delete and refund! This question is answered, by the author, so I recommend "PAQ and refund" for this.
    Consider this as an objection!
    Wish I can help

    Accepted Solution

    Question answered by asker or dialog valuable.
    Closed, 100 points refunded.
    ee_ai_construct (replacement part #xm34)
    Community Support Admin

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
    I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now