Posted by Sabine Dinis Blochberger on 04/24/07 09:59

spamguy21@gmail.com wrote:

> I have a server with Windows 2000, PHP 5, IIS and SQL Server 2000
> running. Individually, each works great. When trying to bring PHP and
> MSSQL together, though, I'm tearing my hair out...it just will not
> connect. Not even an error message.

Have you looked at the event viewer? If you didn't specify for PHP to
log to a file, that's where the errors go...

>
> Consider the code:
>
> <?php
> $server = "localhost"; // have also tried "[servername]", "localhost:
> 1433" and "[servername]:1433"
> $username = "administrator"; // Windows username
> $password = "[password]";
> if (!mssql_connect($server, $username, $password))
> echo "Could not connect.<p>";
> ?>
>
I don't know about MSSQL, but shouldn't you use a MSSQL user (as opposed
to a windows user)?

[Back to original message]