Solved

SQL Connectivty (very broad question)

Posted on 2012-03-26
1
223 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
1 Comment
 
LVL 8

Accepted Solution

by:
Frank McCourry earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

     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 …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now