note 71349 added to function.mssql-connect
| From: | robajz_ at _robajz_ dot _info | Date: | Thu, 23 Nov 2006 14:50:39 +0000 |
| Subject: | note 71349 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-120024@lists.php.net to get a copy of this message | ||
Hi all,
jcastromail at yahoo dot es
Steve H
lbowerh at netscape dot net
munckfish.net
are all talking about SQL Server 2005 Express Edition. I had a problem with it too. It was a pain to
make it working. If you run into a trouble, follow their advices and maybe these three:
try port 1221
play with the SQL Server Configuration Manager
play with the SQL Server Surface Area Configuration
there are many options which may affect this working or not. All you ge is a general message:
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does
not exist or network access denied. (severity 9)
I finaly maked it work with:
$host = 'MACHINENAME'; // see? without \SQLEXPRESS
$port = 1221;
php.ini: mssql.secure_connection = On
ntwdblib.dll: version = 2000.80.194.0
after playing with the configuration tools (enable TCP, and some...). I can't say if playing
with cliconfg has any effect.
HTH, Robert.
----
Server IP: 212.24.129.110
Probable Submitter: 62.84.154.56 (proxied: 1.1 ISA-SERVER)
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/71349
Del: integrated -- https://master.php.net/note/delete/71349/integrated
Del: useless -- https://master.php.net/note/delete/71349/useless
Del: bad code -- https://master.php.net/note/delete/71349/bad+code
Del: spam -- https://master.php.net/note/delete/71349/spam
Del: non-english -- https://master.php.net/note/delete/71349/non-english
Del: in docs -- https://master.php.net/note/delete/71349/in+docs
Del: other reasons-- https://master.php.net/note/delete/71349
Reject -- https://master.php.net/note/reject/71349
Search -- https://master.php.net/manage/user-notes.php