PHP MSSQL Big Problem

kenhess

windows 2k server, php 4.3.4, IIS 5.0
using php_mssql.dll in extensions.
extension is loading...checked with php -m
php is loaded as an ISAPI module
MSSQL does show up in phpinfo.php
php4isapi.dll, ntwdblib.dll are in c:\winnt\system32
Proper setup of SQL Server Alias in SQL network client.

PHP works except for connecting to the MSSQL DB in the browser.

My file works at the command line and I can pull data from the MSSQL DB. c:\test\ php request.php returns my data just fine.

when I use a browser to hit the page, there is no data from the MSSQL DB. This was working just a few days ago, but now, with no code changes, it has stopped.

PHP is working with IIS, because the rest of my page shows up with data pulled from a MySQL DB.

It seems to be a problem with php_mssql.dll but am not sure what it could be.

This is kind of crazy since it was working the other day. Is there some file I need to give the IUSR_COMPUTER access to, to make it work? I had to give that user access to c:\winnt\system32\cmd.exe to get system(), passthru(), and exec() to work.

bastien

Have you created that IUSR_COMPUTER as a user in the DB? It might be permissions problem with the user access

You haven't shown code, but change your query to look like this and see what the error is

$result=mssql_query($sql) or die ("Can't complete query because ".mssql_get_last_message());

which returns a set of error messages of something is not right...see the php doc at www.php.net/mssql_get_last_message

hth

kenhess

ok, I did as you suggested and put in the the get last message and this is the response I got:

Please note: The client tools are installed and the php file does work at the command line...so it seems that it is something with IIS or the permissions for the IUSR or IWAM user.

bastien

Googling for the error (ms sql server errors: Not associated with a trusted SQL Server connection)

got these links

http://www.visual-basic-data-mining.net/Forum/showpost.aspx?PostID=251

http://dbforums.com/arch/70/2003/1/650583

along with others...

basically the jist is that you need to configure SQL Server to allow non NT authorised users to access the db

Read the links for help on doing this

kenhess

It is set for SQL Server and Windows Auth. already.

I am at a loss.

I imported the SQL Server tables I need to MySQL on the localhost to work around the problem but this will come up again...the really weird thing is...this works at the command line AND on other servers. Crazy.