<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML ><HEAD ><TITLE >Is the server there?</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="FreeTDS User Guide" HREF="index.htm"><LINK REL="UP" TITLE="Troubleshooting" HREF="troubleshooting.htm"><LINK REL="PREVIOUS" TITLE="Troubleshooting" HREF="troubleshooting.htm"><LINK REL="NEXT" TITLE="Logging" HREF="logging.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" ><SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN > User Guide: A Guide to Installing, Configuring, and Running <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="troubleshooting.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 8. Troubleshooting</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="logging.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="SERVERTHERE" >Is the server there?</A ></H1 ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.PING" >Start with <B CLASS="COMMAND" >ping</B ></A ></H2 ><P >First <B CLASS="COMMAND" >ping</B > the host to make sure you can talk to the machine the server resides on. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.PING" ></A ><P ><B >Example 8-1. Finding the server's host</B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >ping -c1 <TT CLASS="REPLACEABLE" ><I >myhost</I ></TT ></KBD > <SAMP CLASS="COMPUTEROUTPUT" > PING myhost (127.0.0.1) from 127.0.0.1 : 56(84) bytes of data. 64 bytes from myhost (127.0.0.1): icmp_seq=0 ttl=255 time=250 usec</SAMP ></PRE ></DIV > A successful ping shows that your network isn't preventing you from reaching the machine hosting the server.</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.TELNET" >Test with <B CLASS="COMMAND" >telnet</B ></A ></H2 ><P >Attempt to <B CLASS="COMMAND" >telnet</B > to the port, to verify that the servername is listening. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TELNET" ></A ><P ><B >Example 8-2. Finding the server</B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >telnet <TT CLASS="REPLACEABLE" ><I >myhost 1433</I ></TT ></KBD > <SAMP CLASS="COMPUTEROUTPUT" > Trying 127.0.0.1... Connected to myhost. Escape character is '^]'. </SAMP ></PRE ></DIV > If you get output as above, the servername is listening. If you get a 'Connection Refused' message, you're talking to the wrong host, wrong port, or the servername is down. <A NAME="AEN3073" HREF="#FTN.AEN3073" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.TSQL" >Test with <B CLASS="COMMAND" >tsql</B ></A ></H2 ><P ><B CLASS="COMMAND" >tsql</B > can be run in two ways, one which uses <TT CLASS="FILENAME" >freetds.conf</TT > and one which connects directly using the host and port. First attempt a connection using host and port. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TSQL.NOCONF" ></A ><P ><B >Example 8-3. Connecting to the server, bypassing <TT CLASS="FILENAME" >freetds.conf</TT ></B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >cd src/apps</KBD > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >TDSVER=7.0 ./tsql -H <TT CLASS="REPLACEABLE" ><I >myhost</I ></TT > -p <TT CLASS="REPLACEABLE" ><I >1433</I ></TT > -U <TT CLASS="REPLACEABLE" ><I >user</I ></TT ></KBD ></PRE ></DIV > If you receive a message of 'Login Failed.' then your connectivity is OK, but you have a authentication issue.</P ><P >If you receive a message like <PRE CLASS="SCREEN" > <SAMP CLASS="COMPUTEROUTPUT" >Msg. No.: 18450 Severity: 14 State: 1 Login failed- User: loginid Reason: Not defined as a valid user of a trusted SQL Server connection </SAMP ></PRE > <SPAN CLASS="PRODUCTNAME" >SQL Server</SPAN > is accepting only <SPAN CLASS="QUOTE" >"domain"</SPAN > logins. This applies only to Microsoft <SPAN CLASS="PRODUCTNAME" >SQL Server</SPAN > and you'll need to have your DBA verify that <SPAN CLASS="QUOTE" >"server logins"</SPAN > are allowed, or use a <A HREF="domains.htm" >domain login</A >. </P ><P >Finally, if you received a prompt, then try <B CLASS="COMMAND" >tsql</B > using the servername. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TSQL" ></A ><P ><B >Example 8-4. Connecting to the server using <TT CLASS="FILENAME" >freetds.conf</TT ></B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >./tsql -S <TT CLASS="REPLACEABLE" ><I >myserver</I ></TT > -U <TT CLASS="REPLACEABLE" ><I >user</I ></TT ></KBD ></PRE ></DIV > If this fails, FreeTDS is either not finding your <TT CLASS="FILENAME" >freetds.conf</TT > file, finding the wrong one, or there is an error in the file.</P ></DIV ></DIV ><H3 CLASS="FOOTNOTES" >Notes</H3 ><TABLE BORDER="0" CLASS="FOOTNOTES" WIDTH="100%" ><TR ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ><A NAME="FTN.AEN3073" HREF="serverthere.htm#AEN3073" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></TD ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="95%" ><P >To exit <B CLASS="COMMAND" >telnet</B >: When connected, telnet's command mode may be entered by typing the telnet <I CLASS="FIRSTTERM" >escape character</I > (initially <SPAN CLASS="KEYSYM" >Ctrl</SPAN >-<SPAN CLASS="KEYSYM" >]</SPAN >, as above). Once in command mode, <B CLASS="COMMAND" >telnet</B > may be exited with the command <B CLASS="COMMAND" >quit</B >.</P ></TD ></TR ></TABLE ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="troubleshooting.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="logging.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Troubleshooting</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="troubleshooting.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Logging</TD ></TR ></TABLE ></DIV ></BODY ></HTML >