Skip to Content.
Sympa Menu

freetds - Re: DB-Library: Login incorrect.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Greg Chakmamkian <gregchak AT mac.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: DB-Library: Login incorrect.
  • Date: Wed, 28 Nov 2001 19:31:54 -0500


Usually when you get an error like "Reason: Not associated with a trusted SQL Server connection" its usually because your security on your database is set to NT authentication rather than mixed mode. Mixed mode uses both NT and SQL authentication. My guess is that you either need to login with an NT account or change your security to mixed mode. Hope this helps.

-greg





On Wednesday, November 28, 2001, at 07:21 PM, James Cameron wrote:

G'day,

"Login failed for user 'cameron'. Reason: Not associated with a trusted
SQL Server connection"

I haven't yet figured out the cause of this. Comments welcome.
Microsoft SQL Server 7. Configuration works fine with another server.

However, the odd thing is that I could see this message in the output of
a packet trace, but the cause of the login failure is not propogated
well up the tree. The Apache error.log file has "DB-Library: Login
incorrect.", and the sybase_connect() just returns FALSE. A call to the
function sybase_get_last_message() immediate after this returns "".

I'm using PHP 4.0.3 in CGI mode on this server, with FreeTDS 0.51 or so.

# tcpdump -s 1500 -X -i eth0 -n host 10.0.0.46
[...]
11:08:35.917974 10.0.0.46.1433 > 10.0.0.196.1171: P 1:126(125) ack 589
win 8172 (DF)
0x0000 4500 00a5 bb48 4000 8006 dce6 1099 202e E....H@.........
0x0010 1099 20c4 0599 0493 4ad3 abcf 9836 200b ........J....6..
0x0020 5018 1fec 5a83 0000 0401 007d 0000 0000 P...Z......}....
0x0030 aa69 0014 4800 0001 0e5d 004c 6f67 696e .i..H....].Login
0x0040 2066 6169 6c65 6420 666f 7220 7573 6572 .failed.for.user
0x0050 2027 6361 6d65 726f 6e27 2e20 5265 6173 .'cameron'..Reas
0x0060 6f6e 3a20 4e6f 7420 6173 736f 6369 6174 on:.Not.associat
0x0070 6564 2077 6974 6820 6120 7472 7573 7465 ed.with.a.truste
0x0080 6420 5351 4c20 5365 7276 6572 2063 6f6e d.SQL.Server.con
0x0090 6e65 6374 696f 6e2e 0000 0000 fd02 0000 nection.........
0x00a0 0000 0000 002f 1e6d f9 ...../.m.

--
James Cameron (james.cameron AT compaq.com)

http://quozl.linux.org.au/ (or) http://quozl.netrek.org/

---
You are currently subscribed to freetds as: [gregchak AT mac.com]
To unsubscribe, forward this message to leave-
freetds-136070S AT franklin.oit.unc.edu





Archive powered by MHonArc 2.6.24.

Top of Page