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

SQL Connectivty (very broad question)

We upgraded our accounting software, which is running on SQL 2008 R2. Each user has a client that connects for entering their time each day. I have a handful of users who are crashing after about 10 minutes. Tech support for this product is saying saying it's losing it's connection to the SQL server. At first I thought it was only my wireless users, in which case I found out the company does't support wireless connections (which is terrible for my laptop users), but I've still got some wired desktops having issues. They don't ever lose connection to my document management SQL server, nor the old accounting SQL server. Nothing network wise has changed and I'm having a hard time believing that this many users are having a "connectivity" issue with only this one application. All that to ask this "How do I test SQL connectivity and where would it be timing out at?" These are a mix of WinXP and Win7 workations. Any thoughts would be greatly appreciated.
0
HELFIT
Asked:
HELFIT
1 Solution
 
Frank McCourryV.P. Holland Computers, Inc.Commented:
Check for IPv6 on the new SQL Server.  If your not using this protocol and the rest of your network is not configured for it, the new server may be trying to respond using that protocol instead of IPv4.  Disabling IPV6 is no easy task either.  Read this: http://support.microsoft.com/kb/929852.  

I had similar issues, the reason was that our router was not configured for IPV6 and could not forward the packets.  Way to Go Microsoft!  Enable something by default that your users most likely do not fully support.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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