freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS
- 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
-
[freetds] Connectivity problem from Linux to Sql Server 2000 using FreeTDS,
Murugesan, Prasanna Venkatesh, 10/10/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000 usingFreeTDS,
ZIGLIO, Frediano, VF-IT, 10/10/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/10/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
James K. Lowden, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
James K. Lowden, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/14/2008
- Re: [freetds] Connectivity problem from Linux to Sql Server2000usingFreeTDS, Murugesan, Prasanna Venkatesh, 10/14/2008
- Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS, James K. Lowden, 10/14/2008
- Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS, Murugesan, Prasanna Venkatesh, 10/20/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/14/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
James K. Lowden, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
James K. Lowden, 10/13/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000usingFreeTDS,
Murugesan, Prasanna Venkatesh, 10/10/2008
-
Re: [freetds] Connectivity problem from Linux to Sql Server 2000 usingFreeTDS,
ZIGLIO, Frediano, VF-IT, 10/10/2008
Archive powered by MHonArc 2.6.24.