Solved

SQL Connectivty (very broad question)

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error Creating Foreign Keys in SQL Database 7 35
Replace Dates in query 14 40
Changing the datatype of a column from nvarchar to date 47 20
Help  needed 3 25
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
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 a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 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