It might be worth running netstat on the server to check if SQL Server
is listening on a TCP port. If not, check the config. I think the full
version of SQL Server defaults to using named pipes only, TCP has to be
My textbook also says that SQL Server runs under the 'Local System'
account, which might not have permission to access the network. The
textbook recommends creating a new account with local administrator
rights to run the service (this is for the full version of SQL Server,
the desktop edition is probably the same). I don't know if this is wise
or not, my Windows expertise falls far short of understanding all the
different privilege levels.
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: 22 February 2004 15:57
To: [EMAIL PROTECTED]
Subject: Connect to MSDE using PHP
I've downlownded and installed the Desktop Edition of MSSQL and am
trying to connect to it with PHP. Has anyone ever accomplished this?
I've uncommented the line in php.ini to load the MSSQL functions and
they show up on a phpinfo() page, so that part is good.
When I installed MSDE I tried it without a named instance first and just
set an SA password.
Neither of these worked:
where "coconut" is the name of my computer.
Then I tried installing MSDE again with a named instance and tried
and those wouldn't work either. The only response I get is "failed to
connect to server ..."
I'm off to try ODBC. Anyone have any suggestions?
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals - www.phparch.com
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php