Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Domain Auth to MS SQL - PHP/FreeTDS 0.61: msg#00198

db.tds.freetds

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

I'm back with an update and question:

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';
$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?


-Chris Hettinger, Web Specialist
-IFMC/ENCOMPASS
-www.encompas.com
-(515) 223.2947




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.'


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
hardware.arm.at...    cms.citadel.dev...    video.gstreamer...    java.facelets.u...    misc.basics.qna...    web.wiki.instik...    network.uip.use...    xdg.devel/2003-...    tex.bibtex.bibd...    finance.quotesp...    ietf.zeroconf/2...    redhat.blinux.g...    suse.db2/2003-0...    php.phpesp/2004...    uml.devel/2003-...    gnome.labyrinth...    qnx.openqnx.dev...    boot-loaders.gr...    db.dataperfect....    audio.audacity....    linux.uclinux.m...    editors.j.devel...    os.openbsd.tech...    kde.users.multi...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation