note 60427 deleted from function.mssql-connect by danbrown
| From: | danbrown@php.net | Date: | Sun, 07 Dec 2008 19:38:06 +0000 |
| Subject: | note 60427 deleted from function.mssql-connect by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147869@lists.php.net to get a copy of this message | ||
Note Submitter: Charles Lowe
----
I found this message in the notes below:
"I spent about a day until get working mssql_connect() function. I tried to connect PHP to
MSDE. The solution is Server Network Utility (it is not installed on MSDE + Client tools
configuration, only on SQL Server Standard/Enterprise). The necessary file SVRNETCN.EXE exists on
the installation disk."
This actually fixed my problem that I was running into on a Windows Server 2003 SP1, IIS 6.0, PHP 4
and MSDE 2000 SP3. I copied the SVRNETCN.EXE and SVRNETCN.DLL (located on the SQL Server 2000
Standard CD folder at: x86\binn) to the C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory
on the SQL server.
I ran the SVRNETCN.EXE from the local folder and "Enabled" the TCP/IP and Named Pipes
protocols. With a quick MSSQLSERVER service restart, everything ran perfectly after that.
Hope this helps.