Page 1 of 1

mssql connection problems

Posted: Fri Jun 11, 2004 3:54 pm
by Jeremy108
Windows 2003 server - IIS - 6 and SQL server 2000, php 4.3.5

I have placed the php_mssql.dll in the extensions folder. I have placed the ntwdblib.dll in the system 32 folder (both the latest version and the one from the sql 2000 install cd - tried em both) and I have uncommented the line: extension=php_mssql.dll. After all this, I still get this message:

Warning: mssql_connect(): Unable to connect to server: 152.135.xxx.xxx,1433

I've tried it using localhost and I get this message:
Warning: mssql_connect(): Unable to connect to server: localhost,1433

The ODBC functions connect perfectly, but not the mssql_connect functions.

Any ideas?

Posted: Sat Jun 12, 2004 1:25 pm
by lostboy
have you looked at the exact error msg? Perhaps its a permissions problem, where your user account for the connection doesn't have access to connect from the server