IIS5 with PHP connect to MS SQL on Win2003

I have a Windows 2000 box with IIS5 and PHP 5.04 installed (manual install w/ the zip file). PHP works just fine. I'm trying to connect to a Windows 2003 Server running MS SQL 2000 Server. Both machines are on the same subnet, and I can use any other software to connect between them and its just fine. I'm getting the following error message:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: DOUGHREME in c:\Inetpub\wwwroot\Intranet\address2\index.php on line 16

On the 2k3 server with the DB, I get this in the event log every time I try to load the page. 2005-07-06 13:00:48.90 server    Error: 17832, Severity: 20, State: 10
2005-07-06 13:00:48.90 server    Connection opened but invalid login packet(s) sent.  Connection closed..

I've got the MS SQL Client tools installed on the webserver. I've made sure I'm using the same ntwdblib.dll files. I've tried using sql authentication and nt creditionals in my php script. I do have two instaces on the 2k3server. One is just straight up MS SQL (the one I need) and the other is for BackupExec.

What to do?  Thanks!

Lakee911Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lakee911Author Commented:
Actually, here is the code in my file


<?php
$myServer = "DOUGHREME";
$myUser = "addy";
$myPass = "[password here]";
$myDB = "paycor";

$s = mssql_connect($myServer, $myUser, $myPass);

....snip....
RimvisCommented:
If you have two instances, try to specify port, like this "DOUGHREME,1433" (1433 is default port)
Lakee911Author Commented:
I've tried to specify port 1433 and it's still no go. How do I specify the instance? One if the default one so I'd assume it'd just be server name, no?

Thanks
Jason
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

RimvisCommented:
Yes.
From http://sqljunkies.com/How%20To/BBF1935A-3D85-4C95-B4EC-5CD76A220B39.scuk

Microsoft SQL Server 2000 supports multiple instances of the SQL Server database engine that run concurrently on the same computer. The following are the two types of SQL Server database engine instances: default and named. There can only be one default instance that runs on any computer, and it is identified by the name of the computer on which the default instance runs. The computer name and instance name are typically specified in the following format:
computer_name\instance_name
Lakee911Author Commented:
Yes ... it's using 1433 like I suspected and I've tried DOUGHREME,1433 and its still no go. I've tried the IP address too.

Thanks
RimvisCommented:
Sorry, then I can't help you.
Lakee911Author Commented:
Found a workaround. I switched to named pipes and used the Network Client Utility on the php server.
jrb1senior developerCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:
   PAQ - Refund

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

John Bush
EE Cleanup Volunteer
DarthModCommented:
PAQed with points (500) refunded

DarthMod
Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.