Solved

Yardi Genesis

Posted on 2013-01-31
5
1,707 Views
Last Modified: 2013-02-26
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
Comment
Question by:debcard
  • 3
5 Comments
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
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
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
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
 

Author Comment

by:debcard
Comment Utility
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
 

Accepted Solution

by:
debcard earned 0 total points
Comment Utility
issue is resolved
0
 

Author Closing Comment

by:debcard
Comment Utility
found the DHCp was turned on the router so the server and router were both giving out addresses
1

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now