Each prawn:
The teacher asked to do the mis system is a LAN can be connected, but I couldn't even any how. Hope everybody to help,
Server: Windows XP professional sp2 (can't, the other requirements in this system using);
Client: Windows XP professional sp3;
All equipped with SQL server 2000 and sp3 patches;
I searched the Internet, from the client ping server IP (or database server name), can be; But not use Telnet IP 1433; Netstat - no port 1433 in the an;
How at the end of the open port 1433? I was in the local connection - TCP/IP filtering are all allowed to choose;
With an ODBC connection, even not on;
Where is the problem about? How should I solve?
Thank you very much!

CodePudding user response:

Check the firewall or something.

CodePudding user response:

I have two computer firewall are closed! Should not the question,

reference 1st floor wag_enu response:

check what firewall.

CodePudding user response:

Windows XP professional sp2, sp3 LAN restrictions, unless there is a domain within the local area network (LAN) strategies, each other can't access,
Baidu search inside Windows XP LAN, there is the solution

CodePudding user response:

WINdows's own firewall off, too?
Or try:
The network connection - & gt; Property - & gt; Advanced - & gt; Settings - & gt; Exception - & gt; Add port
In the name of the place, write the name of what you want to fill at port 1433. The determined again.

CodePudding user response:

Widows built-in firewall is off and I tried what you said this problem should not be
If the server cannot use XP!

reference 4 floor wag_enu response:

WINdows's own firewall off, too?
Or try:
The network connection - & gt; Property - & gt; Advanced - & gt; Settings - & gt; Exception - & gt; Add port
In the name of the place, write the name of what you want to fill at port 1433. Sure.

CodePudding user response:

reference 5 floor yuanye7895686 reply:

widows built-in firewall is off and I tried what you said this problem should not be
If the server cannot use XP!
Refer to 4th floor wag_enu response:
WINdows's own firewall off, too?
Or try:
The network connection - & gt; Property - & gt; Advanced - & gt; Settings - & gt; Exception - & gt; Add port
In the name of the place, write the name of what you want to fill at port 1433. Determine again.

Not, or consult a firewall,

CodePudding user response:

Thank you, it is the problem of SQL server 2000, installed a development version! Depressed!

CodePudding user response:

Or not, just MSDE 2000 personal edition can connect remotely.

CodePudding user response:

Not a version problem, personal edition at the time of installation, SQL is not enabled by default tcpip protocol, in the server configuration with it