FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Wow, that was some fast responses! thanks for the help
> so far!
> 
> 
> James, the "missing" help file is at
> http://www.freetds.org/support.html at the "getting
> help" link is broke.  the support.html appears to be
> missing.  :)
> 
> 
> For my problem, I read what you guys were posting and
> I decided to go download a packet sniffer, and see
> what port other windows programs were using to connect
> to the DB.  The sniffer program said 4168.  So I used
> this:
> 
> tsql -S 192.168.111.2:4168 -U 'Abstract\CPARENT' -P
> mypassword
> 

try with 

tsql -H 192.168.111.2 -p 4148 -U 'Abstract\CPARENT'

(and insert password manually, more safe). 

You can also try with

TDSDUMP=stdout tsql -H 192.168.111.2 -p 4148 -U 'Abstract\CPARENT'

to see a bit of informations on screen (logging goes to screen)

> and to my suprise, it looked like it's connecting! 
> However, I must be still doing something wrong.
> 
> Login failed for user 'ABSTRACT\cparent'. Reason: Not
> associated with a trusted SQL Server connection.
> 
> now, when I Ctrl-Alt-Del, windows XP says "cparent is
> logged on as ABSTRACT\cparent" so I'm fairly certain
> that I have that part correct.  I know my password is
> correct.  I can connect with other applications, so I
> have permissions to that DB.  What could I be doing
> wrong?
> 
> 1) Why cant it connect still
> 2) Why isnt it on port 1433.  telnet cant even connect
> here.  well, it's seeing it at least, but that scares
> me it's not at 1433 like it should be?
> 3) As far as servers host name goes, how do i set this
> up?  I'm more of a developer than an admin, and I'm
> unsure as to how linux would know "myserver" is
> currently pointing to "192.168.111.2".  I've tried
> using -H and it doesn't seem to know about the server
> yet.
> 
> thanks again gang!
> 
> -=Kireol
> 

bye
  freddy77