Re: Connectivity problem from Linux to Sql Server 2000usingFreeTDS

Murugesan, Prasanna Venkatesh wrote:
>  
> HI James,
> 
>   Actually I am able to login from the sqlclient (Query Analyser)using
> the same user id and password.

If you export TDSDUMP first, you'll see at the top of the log whether you
successfully connected to the server, something like this:

net.c:204:Connecting to 10.82.225.394 port 1345 (TDS version 8.0)
net.c:258:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:296:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:734:quietly sending TDS 7+ login packet

The text "Login failed for user" comes from the server.  You'll see that
message in the server's response packet.  

If you use TDS 4.2, you'll see the login packet itself, with your password
in plaintext.  

This is a SQL Server login, and not a domain login, right?  A domain login
has to be prefixed by the domain name.  

HTH.

--jkl


> 
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of James K. Lowden
> Sent: Monday, October 13, 2008 6:22 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Connectivity problem from Linux to Sql Server
> 2000usingFreeTDS
> 
> Murugesan, Prasanna Venkatesh wrote:
> > 
> > TDSVER=8.0 tsql -H10.182.92.68 -p3531 -Uibia_ir -Pxxx
> > 
> > I ran like this from the prompt , but i am still getting the same 
> > error
> > 
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > Msg 18456, Level 14, State 1, Server , Line 0 Login failed for user 
> > 'ibia_ir'.
> > Msg 20014, Level 9, State 0, Server OpenClient, Line 0 Login 
> > incorrect.
> > There was a problem connecting to the server
> > 
> > 
> > Do i need to install the Version 8.0?
> 
> If it says it's a login failure, it's a login failure....
> 
> --jkl