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\ANONYMOUS LOGON'. (severity 14)
- I have ntwdblib.dll in my c:\apache2\bin &
c:\php folders (year 2000 version)
- I have extension=php_mssql.dll in my php.ini
- when I run:
Expand|Select|Wrap|Line Numbers
- <?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");
- ....
- ?>
Expand|Select|Wrap|Line Numbers
- 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.