Skip to Content.
Sympa Menu

freetds - Re: [freetds] Domain Auth to MS SQL - PHP/FreeTDS 0.61

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Domain Auth to MS SQL - PHP/FreeTDS 0.61
  • Date: Tue, 19 Aug 2003 18:09:52 -0000

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






Archive powered by MHonArc 2.6.24.

Top of Page