FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2012/10/16 Evan Panagiotopoulos <epanagio AT gmail.com>:
> In the conf file I have
> [MyServer2k]
>         host = 10.1.1.16
>         port = 1433
>         tds version = 8.0
>
>
> When I go through the "is the server there?"  steps I see the following:
>
> root@kcsd-grades [/usr/local/etc/rc.d]# 27 > tsql -H 10.1.1.16 -p 1433 -U

-H does NOT use freetds.conf, use -S, should work (if freetds.conf is
in the right directory).

Probably you want version 7.1 (8.0 is the "old" name for 7.1).

> osdadmin
> locale is "C"
> locale charset is "US-ASCII"
> Password:
> Msg 18456, Level 14, State 1, Server KCSD-ZONE-INT, Line 1
> Login failed for user 'osdadmin'.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server
> root@kcsd-grades [/usr/local/etc/rc.d]# 28 > tsql -S 10.1.1.16 -U osdadmin
> locale is "C"
> locale charset is "US-ASCII"
> Password:
> Msg 20009, Level 9, State 0, Server OpenClient, Line 0
> Server is unavailable or does not exist.
> There was a problem connecting to the server
>
> In the php script I have
>
> putenv('FREETDSCONF=/usr/local/etc/freetds.conf');
> $link = mssql_connect('10.1.1.16:1433', 'osdadmin', '...');
> if (!$link) ...
>
> In the php logs I see:
>
> mssql_connect(): message: Login failed for user 'osdadmin'. (severity 14)
>
>
> I know that the user ID and password that I am using are correct. We tested
> them on the ms sql server and they worked.
> HELP!
>
> --
> Evan Panagiotopoulos

Frediano