Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS
  • Date: Mon, 13 Oct 2008 10:20:25 -0400

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: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] 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




Archive powered by MHonArc 2.6.24.

Top of Page