Kbase P127672: Unable to connect to MS SQL DataServer after Windows update
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/14/2011 |
|
Status: Verified
SYMPTOM(s):
Unable to connect to MS SQL DataServer after Windows update.
Connection failure for host <host_name> port <port> transport <transport_name>. (9407)
DataServer connection failure. (7255)
Failed to connect to the <db-type> database. (6142)
Machine has 2 network interface cards
Client seems to be using the second NIC rather than the first.
Broker registration mode is Use Broker Host IP Address
FACT(s) (Environment):
Windows
OpenEdge 10.x
MS SQL DataServer
CHANGE:
Installed windows updates. After that it seemed that the IP addressed returned by windows when using the broker registration mode of 'Use Broker Host IP Address' was the second NIC not the first as was expected.
FIX:
Changed the broker registration mode to be 'Use Host Name' and supplied the the IP address of the first NIC.