note 28291 deleted from ref.mssql by sniper
| From: | sniper@php.net | Date: | Mon, 17 Nov 2003 22:57:59 +0000 |
| Subject: | note 28291 deleted from ref.mssql by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-60525@lists.php.net to get a copy of this message | ||
Note Submitter: peter@schumacher.dk
----
It's possible to change the default connection type from Named Pipes to TCP/IP
WITHOUT installing the Connectivity-Part from the MSSQL7 Server-cd,
The registry-key,
[HKEY_LOCAL_MACHINE\SOFTWARE\
Microsoft\MSSQLServer\Client\ConnectTo]
holds the current connection-type.
Initially it's set to "DSQUERY"="DBNMPNTW" which corresponds to Named
Pipes.
Change it to "DSQUERY"="DBMSSOCN" which corresponds to TCP/IP.
(Only tested on Win2KPro)