?
Solved

telnet port 1433 blocked

Posted on 2006-04-13
2
Medium Priority
?
997 Views
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 209.132.213.189 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?
Thanks





0
Comment
Question by:Gitti
  • 2
2 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 16459738
check your computer firewall configure it to allow port 1433 this is default port for sql server.

0
 
LVL 28

Accepted Solution

by:
imran_fast earned 1500 total points
ID: 16459744
i mean the client computer.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
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.
Suggested Courses

609 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