Re: PHP connecting to MSSQL

Sascha Meyer wrote:

Hi Alf, I just installed MSDE on my PC and I could connect locally with a trusted connection, using shared memory Net-Library. When connecting using hostname and port, the connection failed, because the server was not listening on port 1433. this will resolve your problem: if you install MSDE without giving the parameter "DISABLENETWORKPROTOCOLS=0", only local access with the Net-Library will be available. You can reactive the network protocols through the client tool "svrnetcn" located in your MSSQL server's "binn" directory and enabling "TCP/IP" (you can also define the used port with this utiliy). Don't forget to restart your SQL Server service! If you now run "netstat -an", you will find your server listening on port 1433. I have not reinstalled MSDE but have done the svrnetcn you suggest where I found 1433 listed as the TCP port but when I try netstat -an I get:-

C:\Documents and Settings\Alf Stockton>svrnetcn C:\Documents and Settings\Alf Stockton>netstat -an Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:80             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:990            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:2869           0.0.0.0:0              LISTENING
  TCP    127.0.0.1:1026         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:1094         127.0.0.1:30606        ESTABLISHED
  TCP    127.0.0.1:5152         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:5679         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:7438         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:30606        0.0.0.0:0              LISTENING
  TCP    127.0.0.1:30606        127.0.0.1:1094         ESTABLISHED
  TCP    192.168.30.192:139     0.0.0.0:0              LISTENING
  TCP    192.168.30.192:1095    72.5.124.55:80         ESTABLISHED
  UDP    0.0.0.0:445            *:*
  UDP    0.0.0.0:500            *:*
  UDP    0.0.0.0:1028           *:*
  UDP    0.0.0.0:4500           *:*
  UDP    127.0.0.1:123          *:*
  UDP    127.0.0.1:1029         *:*
  UDP    127.0.0.1:1900         *:*
  UDP    192.168.30.192:123     *:*
  UDP    192.168.30.192:137     *:*
  UDP    192.168.30.192:138     *:*
  UDP    192.168.30.192:1900    *:*

as you can see no 1433? -- Regards, Alf Stockton www.stockton.co.za In the first place, God made idiots; this was for practice; then he made school boards. -- Mark Twain