FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: Un Named
> Subject: [freetds] MS SQL 2005 + PHP 5.20 + FreeTDS 9.64
mssql_connectfailed (Login incorrect...)
> 
>   I am trying to perform some simple queries agains a 
>   remote MS SQL 2005 server. If I am trying with a 
>   SQL manager, i.e. EMS SQL Manager 2005 Lite fro SQL Server, 
>   I can connect and do the queries; hoever if I am 
>   trying with a simple php code it doesn't.
...
>   [PHP Code]
>   <?
>       $dbhost = "Server_IP:1433";
>     $dbuser = "user";
...
> 11:16:16.970076 23964 (net.c:542):Received packet
> 0000 aa 52 00 18 48 00 00 01-0e 1d 00 4c 00 6f 00 67 |.R..H...
...L.o.g|
> 0010 00 69 00 6e 00 20 00 66-00 61 00 69 00 6c 00 65 |.i.n. .f
.a.i.l.e|
> 0020 00 64 00 20 00 66 00 6f-00 72 00 20 00 75 00 73 |.d. .f.o .r.
.u.s|
> 0030 00 65 00 72 00 20 00 27-00 75 00 73 00 65 00 72 |.e.r. .'
.u.s.e.r|
> 0040 00 27 00 2e 00 06 42 00-4c 00 4f 00 4f 00 4b 00 |.'....B.
L.O.O.K.|

That's the server telling you "Login failed for user 'user'".  Unless
you have a user whose name is 'user' and whose password is 'password',
that's the message I'd expect to see.  

What else do you want to know?  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.