Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
April 4, 2007, 11:40 pm
rate this thread
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.");
or die("Couldn't connect to Server database.");
The error is "Couldn't connect to Server", so the first connection
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
-Added my Windows account to the administrators in SQL Server Surface
-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.
Suggestions in addition to the above are very much appreciated.
Thanks in advance,
Re: PHP, Apache, SQL Server 2005 Express - on Vista
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:
and see what error messages you get. It's likely to be a problem with your
setup, not the code.
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 ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux
* = I'm getting there!