RE: Domain Auth to MS SQL - PHP/FreeTDS 0.61

Thanks I did switch the $db_host to ENCPPP, know by freetds.

I did get rid of the errros I mentioned but only by switching the SQL server's 
auth type to "SQL and Window" in the security tab.

As far as I can tell, though Domain Support has been added to freetds as of 
0.60, it doesn't seem to be working. But really, what do I know ... just what I 
can gather, and it may be something I missed.

I really appreciate the help.

-ch

-----Original Message-----
From: Frediano Ziglio [mailto:freddyz77@xxxxxx]
Sent: Tuesday, August 19, 2003 1:10 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Domain Auth to MS SQL - PHP/FreeTDS 0.61


Il mar, 2003-08-19 alle 18:49, Chris Hettinger ha scritto:
> I'm back with an update and question:
> 

Hi Chris!

> I have freeTDS 0.61 libraries installed, and I now have PHP recompiled with 
> the inclusion of MSSQL support. I am using a very simple script to test my 
> connection to the SQL DB, but again am running into:
> =====================
> $db_host = '192.168.1.245';

^^^^ I think this line is the problem. Try $db_host = 'ENCPPP'; (freetds
server name, not ip)

> $db_user = 'chettinger';
> $db_pass = '<PASSWORD>';
> $db_database = 'PHPTEST';
> 
> include("../adodb/adodb.inc.php");
> include("../adodb/tohtml.inc.php");
> 
> // Do database connection
> ADOLoadCode('mssql');
> $db = NewADOConnection('mssql');
> if(!$db->Connect($db_host, $db_user, $db_pass, $db_database))
> {
>    message_die(CRITICAL_ERROR, "Could not connect to the database", __LINE__, 
> __FILE__);
> }
> 
> //
> // Select data
> //
>   $sql = "SELECT * FROM profile";
>   echo "<font color=blue size=1><br>".$sql."</font><p>";
>   $rsData = $db->Execute($sql);
> 
>   if(!$rsData){
>     print "Bad";
>   }else{
>     print "Good";
>   }
> =====================
> I receive two warnings:
> Login failed for user 'chettinger'. Reason: Not associated with a trusted SQL 
> Server connection
> Unable to connect to server: 192.168.1.245
> But my if statement still prints "Good"
> 
> Our SQL Server is set up to use NT domain authentication.
> My freetds.conf:
> 
> [ENCPPP]
>         host = 192.168.1.245
>         port = 1433
>         tds version = 7.0
>         try domain login = yes
>         try server login = no
>         nt domain = ENCOMPASS
> 
> TSQL:
> $ tsql -S ENCPPP -U chettinger          <--------- My domain login.
> locale is "en_US"
> using default charset "ISO-8859-1"
> Password:
> Msg 5703, Level 0, State 1, Server ENCPPP, Line 0
> Changed language setting to us_english.
> 1>
> 
> ... It appears as though FreeTDS is there and I can connect correctly.
> 
> 
> My question is, though I have recompiled php and the freetds libraries are on 
> the server, how can I test they are communicating? Or have I missed something?
> 

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS@xxxxxxxxxxxxxxxxx
http://lists.ibiblio.org/mailman/listinfo/freetds


CONFIDENTIALITY NOTICE:  This communication, including any attachment, may 
contain confidential information and is intended only for the individual or 
entity to whom it is addressed.  Any review, dissemination, or copying of this 
communication by anyone other than the intended recipient is strictly 
prohibited.  If you are not the intended recipient, please contact the sender 
by reply email, delete and destroy all copies of the original message.'