- Server MS Windows 2003, dual NIC cards.
- Managed 16 port ethernet switch.
- On server both NIC card go to Managed switch. One is addressed on the 10.x.x.x side, the other is addressed on the 192.x.x.x side
- FPMI, FSQL, MS-SQL are all on this server.
- All servers are on UPS.
- Managed switches are not on UPS.
Problem - Out of the past 6 weeks there has only been one monday morning when we have come in and our SCADA system has worked properly. The other 5 weeks each monday morning the system has been down due to loss of connectivity with the datasource.
If you go in thru the gateway and restart the PMI, the datasource will reconnect but as soon as you try to run any type of query it drops connection.
I.T. dept thinks that it is because the managed switch is not on a UPS and when their is a power outage the servers stay up and running because they are on a UPS but the managed switch does not and that in turn makes it a problem for FPMI and sometimes FSQL to log backin and reattach to the database.
Current config has both FSQL and FPMI looking at the IP address of the server. But I am wondering if since all these items are on the same server if looking back at local host would be a better option. Example: Instead of looking at say 192.168.1.80:5055, have it set at 127.0.0.1:5055. Just some thougths I am throwing out there.
So has anyone had any similar problems, is this a known problem and all our managed switches should also be on a UPS, or any other thoughts greatly welcomed.
Hope this is clear and have a great day.