• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2248
  • Last Modified:

Yardi Genesis

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
0
debcard
Asked:
debcard
  • 3
1 Solution
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
I would check what netstat says about the connections from the klient.
I would check the FW on the XP to make sure it's not dropping any packages

If this doesn't give me all the info I need I would install the netmon tool and sniff the traffic to see whats happening.

To learn about netmon look at:
http://blogs.technet.com/netmon
http://msdn.microsoft.com/en-us/library/windows/desktop/bb648688(v=vs.85).aspx
http://support.microsoft.com/kb/812953
http://blogs.technet.com/b/netmon/
http://blogs.technet.com/b/netmon/p/usagevideos.aspx
http://technet.microsoft.com/en-us/library/cc782726(v=ws.10).aspx

Regards Marten
0
 
David ToddSenior DBACommented:
Hi,

To go back half a step, can these three clients ping the server? You indicated that for one or more there was an issue with the ip address, or maybe the dns entry.

You could try for these three putting an entry into the hosts file.

Check them for virus and other malware which may be getting into the dns thing and not resolving ip addresses properly.

HTH
  David
0
 
debcardAuthor Commented:
Actually this afternoon we checked the server which is a DHCP server and found issues there, I believe the issue is resolved

Thank you

Will repost if still an issue
0
 
debcardAuthor Commented:
issue is resolved
0
 
debcardAuthor Commented:
found the DHCp was turned on the router so the server and router were both giving out addresses
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now