I have a client that 2 days ago they started to receive the following error when logging into their Yardi database
Login Failed with error 1:
Couldn’t access the database server “apmyardi\yardipm”. The engine must be installed and running. ADO returned error: 0 – Timeout expires.
Three users do not have this issue but 21 do. Checked if it was an issue with a switch, people who can and cannot log in are on the same switch, moved a computer that could not connect to the data port of one that could and it was fine. After much troubleshooting, if i release and renew the IP address they can log in. Problem is, if they close the program and reopen it, they have to first release and renew the IP. They are on a DHCP server. All users are running Windows XP Pro SP3
Any insight would be great