telnet port 1433 blocked

Posted on 2006-04-13
Last Modified: 2008-02-26
My actual problem is this Runtime error on my application:

"An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

I have gone through lots of instructions and steps:
>ask your ISP to enable TCP/IP to allow remote connections on the SQL2K5 server
>ISP (webprovider): Please run the below command and paste us the result.
telnet 1433
>Telnet can't connect to this IP
>ISP (web provider): Some ISPs block outgoing port 1433, please contact your ISP and ask them to open the port for you.
>ISP2 (Internet Provider): We do not block anything. It depends on your local computer's settings. Or you may call Microsoft ...
...Now I don't know what to do? Any hints or help please?

Question by:Gitti
    LVL 28

    Expert Comment

    check your computer firewall configure it to allow port 1433 this is default port for sql server.

    LVL 28

    Accepted Solution

    i mean the client computer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    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.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 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