?
Solved

Connection Dropouts to Database on Windows Server 2008 R2 DFS

Posted on 2017-03-13
12
Medium Priority
?
69 Views
Last Modified: 2017-03-14
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.
0
Comment
Question by:Zack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 18

Expert Comment

by:John Tsioumpris
ID: 42047190
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
 

Author Comment

by:Zack
ID: 42047244
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
 
LVL 18

Expert Comment

by:John Tsioumpris
ID: 42047259
Can you give some more info on how you are connected to the Datacenter...?
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

Author Comment

by:Zack
ID: 42047265
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
 
LVL 18

Accepted Solution

by:
John Tsioumpris earned 2000 total points
ID: 42047267
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
 

Author Comment

by:Zack
ID: 42047276
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
 

Author Closing Comment

by:Zack
ID: 42047278
Thank you for the assistance.
0
 
LVL 18

Expert Comment

by:John Tsioumpris
ID: 42047291
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
 

Author Comment

by:Zack
ID: 42047480
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
 
LVL 18

Expert Comment

by:John Tsioumpris
ID: 42047489
I guess besides Logging you could implement some transaction mechanism so if the data are not delivered to retry to fetch them...
0
 

Author Comment

by:Zack
ID: 42047490
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
 
LVL 18

Expert Comment

by:John Tsioumpris
ID: 42047491
Hope you resolve it...
1

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to install and use the NTBackup utility that comes with Windows Server.
WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Suggested Courses

765 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