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.
Regards, Sascha
Alf Stockton schrieb:
Sascha Meyer wrote:
Hi Alf,
your local SQL Server is probably listening on another port ...
perhaps you could try the following in a DOS prompt:
netstat
and
netstat -n
The first should give you all open local ports with descriptions to
the port if a default port was used. The second will give you all
open ports with port numbers instead of protocol names. This could
help you check if your server is listening on another port.
The results of your above was/is:-
C:\Documents and Settings\alf>netstat
Active Connections
Proto Local Address Foreign Address State
TCP k9pad:1032 k9pad:1522 ESTABLISHED
TCP k9pad:1522 k9pad:1032 ESTABLISHED
TCP k9pad:1045 localhost:27015 ESTABLISHED
TCP k9pad:27015 localhost:1045 ESTABLISHED
C:\Documents and Settings\alf>netstat -n
Active Connections
Proto Local Address Foreign Address State
TCP 10.0.0.3:1032 10.0.0.3:1522 ESTABLISHED
TCP 10.0.0.3:1522 10.0.0.3:1032 ESTABLISHED
TCP 127.0.0.1:1045 127.0.0.1:27015 ESTABLISHED
TCP 127.0.0.1:27015 127.0.0.1:1045 ESTABLISHED
but I do not see mssql in either of those results?
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
