I am running a WinXP Pro w/ SP2 (my home computer)
Apache 2.2.11
MySQL 5.1.33
PHP 5.2.9
I have to connect a remote MSSQL database
IIS
MS SQL Sever 2005
I am getting error
Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'. (severity 14)
- I have ntwdblib.dll in my c:\apache2\bin &
c:\php folders (year 2000 version)
- I have extension=php_m ssql.dll in my php.ini
- when I run:
in php.ini file i set
I know that the $host, $user, and $password are right because I can
connect to the remote DB with the client tools.
Please help me.
Apache 2.2.11
MySQL 5.1.33
PHP 5.2.9
I have to connect a remote MSSQL database
IIS
MS SQL Sever 2005
I am getting error
Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'. (severity 14)
- I have ntwdblib.dll in my c:\apache2\bin &
c:\php folders (year 2000 version)
- I have extension=php_m ssql.dll in my php.ini
- when I run:
Code:
<?php $host="mssql2.alpha.aussiehq.net.au"; $user="user"; $password="password"; mssql_connect($host,$user,$password) or die ("could not connect to server"); // <-------- It always dies here. :( mssql_select_db("trtrades") or die ("could not connect to DB"); .... ?>
Code:
mssql.allow_persistent = On mssql.max_persistent = -1 mssql.max_links = -1 mssql.min_error_severity = 10 mssql.min_message_severity = 10 mssql.compatability_mode = On ;mssql.connect_timeout = 5 ;mssql.timeout = 60 ;mssql.textlimit = 4096 ;mssql.textsize = 4096 ;mssql.batchsize = 0 ;mssql.datetimeconvert = On mssql.secure_connection = Off mssql.max_procs = 25
connect to the remote DB with the client tools.
Please help me.
Comment