Previous version with PB7.0 + SQLSERVER2000 personal development is good, in a local area network computer (the server operating system, the installation is also 2000 people) is installed on the
Personal edition, to build a database, and then copy the application on the client side, and then installed on the client SQLSERVER2000 [link] only, then the application with the database server in the configuration file name to the computer containing the database name, run the program with respect to ok, this time is a [can't connect to the database] such a hint!!!!!!

Confused:
1) whether formal use should not be put personal edition, standard edition and should hold?
2) in the past in the local area network (LAN), computer is done with fixed IP address, now the network is used to obtain an IP address automatically, is caused by the client to run the program, when connecting to the database, can't find in the network that is equipped with the database server, which means failed to put the computer name parsing out the problem?

Please help to analyze what's the problem? How to solve?

Thank you very much!

CodePudding user response:

SQLSERVER2000 personal version if need client connection, attention to sp4 patch

CodePudding user response:

As with the
1,2, no matter how it also is one of the server, or a fixed IP good

CodePudding user response:

refer to the second floor ehxz response:

1, the same as using
2, no matter how it also is one of the server, or a fixed IP good

Then I set the machine alone a fixed IP, and then change the server name in the configuration file to just the IP, even the same

CodePudding user response:

1 \ \ check the server's firewall, if it is open, add a rule that allows access to port 1433
2 \ \ open SQL SERVER enterprise manager, PM - local - management - SQL log - current, to see if there are any is listening at the right. Your SERVER IP: 1433
3 \ \ can be on any one computer in the network. The run CMD, and then TELNET server IP 1433 to see whether the black screen. If it is, is a sign of the server can access 1433, if there is a hint, showed the server not to.

CodePudding user response:

reference 4 floor herolion2010 response:

1 \ \ check the server's firewall, if it is open, please add a rule that allows access to port 1433
2 \ \ open SQL SERVER enterprise manager, PM - local - management - SQL log - current, to see if there are any is listening at the right. Your SERVER IP: 1433
3 \ \ can be on any one computer in the network. The run CMD, and then TELNET server IP 1433 to see whether the black screen. If it is, just 1433 can access the server, if...

Thank you very much! First try,

CodePudding user response:

reference 1st floor lzp_lrp response:

SQLSERVER2000 personal version if need client connection, be careful to sp4 patch

Thank you in two post, reply, I'll next SP4,

CodePudding user response:

Right-click on the tray is essentially server icon, see about,,,

If display the version number is: 8.00.2039 explains namely has good SP4 patch,