mssql connection problems

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Jeremy108
Forum Newbie
Posts: 5
Joined: Tue Jul 15, 2003 5:12 pm

mssql connection problems

Post 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?
lostboy
Forum Contributor
Posts: 329
Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada

Post 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
Post Reply