[UPHPU] Database Connection issues with SQL Server

[thebigdog]

> 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