note 49461 deleted from function.mssql-connect by cmb

Note Submitter: Ilmars Poikans ---- Connecting to MS SQL server over TCP/IP. I'm working on Windows XP with PHP5 (should work with PHP4 also because ntwdblib.dll is the same). My problem was that I needed to connect to remote MS SQL server over TCP/IP (named pipes weren't an option), but I couldn't, because named pipes were used all the time. One of the possible solutions is to install SQL Client Tools and configure TCP/IP support. I hadn't SQL Server installation disk, so I found fast solution with registry editing. I added to registry following entry: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSSQLServer\Client\ConnectTo] (strip space) "DSQUERY"="DBNETLIB" It worked! Just specify servername in form "host" or "host,port". I successfully connected to remote MSSQL7 and MSSQL2000. I have found on Internet alternative solution that you need to add "DSQUERY"="DBMSSOCN", but it didn't work for me. If you need more connection tweaking like [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSSQLServer\Client\DB-Lib] (strip space) "AutoAnsiToOem"="ON" "UseIntlSettings"="ON" and more, then better find and install SQL Client Tools.