Advertisement

06.14.2008 at 04:29AM PDT, ID: 23484903
[x]
Attachment Details

SQL Server Express 2005, TELNET, and Port 1433

Asked by jdana in SSH / Telnet Software, SQL Server 2005

Tags: Microsoft, SQL Server Express 2005

I was configuring a client yesterday for a SQL Server 2005 Express DB.  Before building the ODBC connect string, I ran ping <IP Address>; the server replied.  I then ran TELNET <IP Adress> 1433 (1433 being the SQL over TCP port number).  I received the following response: "Connecting To <IP Address>...Could not open connection to the host, on port 1433:"  Here's the weird part, I tried the ODBC connect string, and it worked.  I double-checked, the host name specified in the ODBC connect string does match the IP address.  Up until yesterday, I'd assumed that port 1433 had to be open on the SQL server for a client / server connection to be successful.  Am I wrong.  Or, is my understanding of TELNET as a "port pinger" flawed.  Start Free Trial
 
Loading Advertisement...
 
[+][-]06.14.2008 at 04:32AM PDT, ID: 21784885

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 04:39AM PDT, ID: 21784910

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 04:52AM PDT, ID: 21784936

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 05:00AM PDT, ID: 21784954

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 06:05AM PDT, ID: 21785218

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 06:23AM PDT, ID: 21785311

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 06:32AM PDT, ID: 21785333

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 06:38AM PDT, ID: 21785342

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 07:02AM PDT, ID: 21785420

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 07:06AM PDT, ID: 21785432

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 02:27PM PDT, ID: 21786704

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SSH / Telnet Software, SQL Server 2005
Tags: Microsoft, SQL Server Express 2005
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628