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.
ZackGeneral IT Goto GuyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
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
0
ZackGeneral IT Goto GuyAuthor Commented:
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>
0
John TsioumprisSoftware & Systems EngineerCommented:
Can you give some more info on how you are connected to the Datacenter...?
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

ZackGeneral IT Goto GuyAuthor Commented:
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.
0
John TsioumprisSoftware & Systems EngineerCommented:
So its out of the premises....have you checked your network connectivity to see if its stable...some applications by nature are sensitive to latency and packet dropping...have you contacted the DataCenter to inform them about your issue...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ZackGeneral IT Goto GuyAuthor Commented:
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.
0
ZackGeneral IT Goto GuyAuthor Commented:
Thank you for the assistance.
0
John TsioumprisSoftware & Systems EngineerCommented:
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...?
0
ZackGeneral IT Goto GuyAuthor Commented:
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 :)
0
John TsioumprisSoftware & Systems EngineerCommented:
I guess besides Logging you could implement some transaction mechanism so if the data are not delivered to retry to fetch them...
0
ZackGeneral IT Goto GuyAuthor Commented:
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.
0
John TsioumprisSoftware & Systems EngineerCommented:
Hope you resolve it...
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.