Solved

SQL Connectivty (very broad question)

Posted on 2012-03-26
1
229 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 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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