[UPHPU] Database Connection issues with SQL Server

[Mike Mackrory]

Thanks Big Dog!  I'll give that a go. 

-----Original Message-----
From: thebigdog [mailto:bigdog at venticon.com] 
Sent: Thursday, January 29, 2009 3:00 PM
To: mike at echovue.com
Cc: uphpu at uphpu.org
Subject: Re: [UPHPU] Database Connection issues with SQL Server

> Last we we finally got the webserver working as it should and talking 
> to the database.  When I am on the web server box itself I have no 
> problems connecting.
> 
> However if I go to another PC and bring up the web application, the 
> connection to the database server cannot be established.
>  
> Has anyone had any experience with this or know some good ways to 
> troubleshoot the problem?  I suspect it may have to do with 
> authentication, but I'm don't have any idea what IIS uses to authenticate
with SQL Server.
>  
> The statement where it initially dies is mssql_connect(Server, 
> Username,
> Password) - although it appears that the variables for user name and 
> password are never actually used.
>  
> What has me baffled is that it should be the same whether I'm running 
> it from localhost/webapp/index.php or webserver/webapp/index.php.
>  
> Anyone have any suggestions?

Mike,

check and see if you have this dll in the php dir or sub dirs on the server:

ntwdblib.dll and then check and see if you have one under
C:\windows\system32 or equivalent for your windows version.  If you have one
under the system32 dir then i would suggest moving the one under php out of
there and put it in a backup directory or someone outside of php. Then try
again and see if that works for you.


--
thebigdog