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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
