Consult everybody warrior, I met a strange phenomenon, we have a client (operating system is xp) program is a c # development, needs to connect the background of essentially a server database (server operating system is xp), source directly connect to the database is written in the death of the server machine name and database name and password, has been used very well, before connection is also very normal, but recently the client's operating system is out of order, we do the xp system (and xp version is not the same as before), and then run the program wasn't on the original database backend server connection, but the connection another Windows 7 system standby server is normal, the name of the machine can also ping ping server, and enable the spare the client computer (xp) connect the backend server is normal, this is how to return a responsibility?

CodePudding user response:

There are three conditions to know:
1, Windows XP computer, can ping server XP?
2, ping, use SSMS connect to the server database, look at the situation, in general, reshipment system is closed for inbound IGMP protocol specification, to enable it is normal,
3, the third is the most complex, the server program is binding for each client SID unique identifier (operating system), the nong will write programs to solution, (unlikely)

CodePudding user response:

Thank the son porch! The first has been ruled out, as for the second, the new do the standby server, the client can connect a second can also be eliminated? A third possibility is like what you have said is very small, several machines are to get the computer store to install the operating system, after come back factory and in accordance with the software

CodePudding user response:

https://blog.csdn.net/yenange/article/details/50853083

Have a look at my blog, the most important is whether the Telnet IP port can pass?
If you can, certainly can access,
Key should be database server, and this machine is not what you the xp system,
The database server is likely to set a white list, and you the xp machine this machine is not the white list,

CodePudding user response:

Thank you for your song, I see if used to set a white list

CodePudding user response:

refer to the second floor sleihd response:

thank the son porch! The first has been ruled out, as for the second, the new do the standby server, the client can connect a second can also be eliminated? A third possibility is like what you have said is very small, several machines are to get the computer store to install the operating system, after come back factory and in accordance with the software

Don't wulitou disorderly guess, the first to find out, where the server is Taiwan, ping, on this function cannot under test server database,
Can, just look at the software, is to use port 443, or other designated ports,

Sure, after you to reinstall the client machine, check that the firewall and port is normal, and open,
To try to see whether they can connect up,

Not to use the software connection, is to use SSMS connection, I remember the xp can only use sql2000 or SQL express version of 2005, a higher version does not support,

CodePudding user response:

Reinstall the client for machine to connect server is normal, reinstall the client connect to the server for machine is normal

CodePudding user response:

Problem solved, another version of the xp operating system, it is good?