Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Connectivty (very broad question)

Posted on 2012-03-26
1
Medium Priority
?
231 Views
Last Modified: 2012-06-21
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
Comment
Question by:HELFIT
[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
1 Comment
 
LVL 9

Accepted Solution

by:
Frank McCourry earned 2000 total points
ID: 37767988
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

636 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