Avatar of Zack
Zack
Flag for Australia asked on

Connection Dropouts to Database on Windows Server 2008 R2 DFS

Hi EE,

We have a legacy application that is installed locally on client machines and connects to a database which is stored on DFS. The problem is that program is losing connection randomly to the database it requires.  This problem started occurring after we started hosting our DFS in a Datacentre so I am sure it's a network issue of some sort, my query is there a way to prioritize resources on a DFS? If not how would I begin troubleshooting this issue?

Thank you.
Windows NetworkingNetworking* Distributed File System (DFS)Windows Server 2008

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
John Tsioumpris

I think you answered the question by yourself as you stated  " started hosting our DFS in a Datacentre"
I will take a guess and the DataCenter is not outside your premises and you are connected by some way...the problem relies on the connection...this is what it needs troubleshooting
Zack

ASKER
Hi John,

I agree John how would go about troubleshooting this, are there any tools to troubleshooting network connection issues on a Windows DFS.

Additionally, the user's access to the DFS isn't stopped just this programs access the DFS database file store is lost

https://technet.microsoft.com/en-us/library/cc962144.aspx

This article isn't of much help.

Any ideas>
John Tsioumpris

Can you give some more info on how you are connected to the Datacenter...?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Zack

ASKER
Hi John,

We are connecting via Cisco router which hands all external network connections. What type of details do you need I can inquire with vendor?

Thank you.
ASKER CERTIFIED SOLUTION
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Zack

ASKER
Hi John,

I have informed the datacentre about the issue they are unsure of where to start. I can check if the application has timeout option I can configure and set it for longer.

Thank you for the suggestions.
Zack

ASKER
Thank you for the assistance.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
John Tsioumpris

Since you have access to the code ( i guess since you control timeout) you could make a routine to log connection problems (timeout)...in what language your application is coded...?
Zack

ASKER
Hi John,

The language Visual Basic 6.0, I have already have contacted one of our developers about logging the connection issues at least I can capture it when it occurs.  

Thank you for the additional advice this will be long case either way :)
John Tsioumpris

I guess besides Logging you could implement some transaction mechanism so if the data are not delivered to retry to fetch them...
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Zack

ASKER
Hi John,

Cheers for the link

https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/begintrans-committrans-and-rollbacktrans-methods-example-vb

I will forward that on to the developer.

Thanks again.
John Tsioumpris

Hope you resolve it...