PHP, Apache, SQL Server 2005 Express - on Vista

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Has anyone had any success running SQL Server Express on Vista with
Apache via PHP?
My PHP works fine, Apache works fine, and SQL Server Express works
fine in Management Studio, but I cannot connect via this call:

$myServer = "servername";
$myUser = "username";
$myPass = "password";
$myDB = "myDB";

$conn = mssql_connect($myServer, $myUser, $myPass)
    or die("Couldn't connect to Server.");

mssql_select_db($myDB, $conn)
    or die("Couldn't connect to Server database.");

The error is "Couldn't connect to Server", so the first connection
statement fails.

The code works fine on a Windows XP machine with Apache as well as a
Windows Server 2003 running IIS, so I don't think that's the problem.
My Apache and PHP work fine on the Vista machine, since phpinfo()
outputs correctly.  SQL Server Express works fine by itself as well -
it is the latest version of the software, downloaded quite recently,
so it works fine with Vista.
I have tried  the following:
-Enabled TCP/IP, Named Pipes, VIA, and Shared Memory in SQL Server
Configuration Manager.
-Added my Windows account to the administrators in SQL Server Surface
Area Configuration.
-Tried "servername\sqlexpress" and just "sqlexpress", instead of
"servername", in the above connection string.
-Tried turning on mssql.secure_connection in php.ini and then
connecting to port 1443.
-Tried placing php.ini in C:\windows and php_mssql.dll in C:\windows
-I searched google for solutions.  In addition to the above, one
suggestion was made that a file called ntwdblib.dll needs to be
upgraded.  I believe this is an IIS specific file since I don't have
it on my system, so it shouldn't apply in my case.
Any ideas?
Suggestions in addition to the above are very much appreciated.
Thanks in advance,
Simon Gottesman

Re: PHP, Apache, SQL Server 2005 Express - on Vista

hey, have you tried disabling the firewall and any security related to
this service? just asking since vista has it`s own ideas about what
should run and not and usually doesn`t ask you about it.

Re: PHP, Apache, SQL Server 2005 Express - on Vista

sgottenyc wrote:

Quoted text here. Click to load it

No, but I've done this on Linux. The code you posted looks fine. Turn on
all error reporting at the top of your file:

    ini_set('display_errors', TRUE);

and see what error messages you get. It's likely to be a problem with your
setup, not the code.

Quoted text here. Click to load it

You definitely need this file. See the "Requirements" section on this

I don't think SQL Server Express includes this file, but it does come with
SQL Server 2000. It's probably also in SQL Server 2000 SP4, but that's
quite a big download. Ooh look... it seems someone's uploaded that file

I wonder who that was.

Toby A Inkster BSc (Hons) ARCS
Contact Me ~
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

Re: PHP, Apache, SQL Server 2005 Express - on Vista

Quoted text here. Click to load it

Thanks Toby,
That did it - placing the downloaded ntwdblib.dll in C:\php and C:
\winnt\system32 did the trick!
(And here I was starting to consider downgrading to Windows XP
Thanks again and take care,

Site Timeline