The tag has no wiki summary.

learn more… | top users | synonyms

6
votes
2answers
309 views

SQL Server Management studio slow connection or timeout when using Windows Authentication

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication. This happens when ...
0
votes
1answer
90 views

I keep getting an error 10060 trying to connect object explorer in Visual Studio 2013 to an Azure Database

Using Win 7, Visual Studio 2013, (or Sql management tool 2014) This is for a class and its all software on the trial period. In Visual Studio server explorer - I can connect to the Azure Server I ...
1
vote
1answer
164 views

Is there a timeout option for remote access to PostgreSQL database?

I'm working via pgAdmin III on a remote PostgreSQL database. After a not so long period (say 10-15 min.) without doing anything in pgAdmin, the connection automatically expires. I therefore have a ...
0
votes
2answers
314 views

mysql connection timeout on small traffic server

How can I set up MySQL so that connections never time out? And how do I even check to see what the current settings for variables such as wait_timeout and interactive_timeout, etc. are? Given that ...
1
vote
1answer
115 views

SELECT RELEASE_LOCK causing “Mysql has gone away”

During a long running process (90m+), our code calls SELECT RELEASE_LOCK('..');. However it always gives a "Mysql has gone away" error when we do this. We have tried a number of things including ...
0
votes
1answer
76 views

SSMS 2008 R2 no longer connects to database [closed]

Before Christmas I had no problem connecting SSMS 2008 R2 to a specific remote database. Since Christmas, I get this error when I try to connect: TITLE: Connect to Server Cannot connect to ...
2
votes
0answers
3k views

The underlying provider failed on Open. Error in Windows Service

I have a Windows Service(c#) that receives data and inserts it into DB using Entity Framework 6. Database is SQL Server 2014 Enterprise Edition. Both (Service and DB) are hosted on VPS( Windows Server ...
3
votes
3answers
2k views

Tracking Down Application Timeout Errors in SQL Server

SQL Server 2008 SP3 How do I track down these timeout errors ? The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a ...
3
votes
0answers
105 views

Unable to Update on SQL Server 2008 R2

This is a bit strange so bear with me please. After installing a new SQL Server 2008 R2 on a new server (Windows 2012 Standard) just like the production one, I tried to connect my web aplication ...
0
votes
0answers
295 views

Configuration to stop mysql sleep

I am trying to configure a mariadb / mysql instance to stop sleeping when there is no activity for a while. The reason being is that I keep getting the following exception in my java logs when nobody ...
2
votes
0answers
632 views

Getting “Read Timed Out” exception frequently for last few days on my already running SQL Server 2008 R2

Our client has a setup of 2 VMs . One of them has SQLServer 2008 R2 and other has a Java utility which I am using to update the Database.. It was working some time back, but recently it started ...
5
votes
1answer
2k views

SQL Server AlwaysOn Error_number 35206

I've joined a Ecommerce business where they use SQL Server 2012 AlwaysOn for HADR and this is the first time I've come across supporting this technology. The Sql Server log on both nodes gets ...
5
votes
0answers
190 views

Frequent, “random” SQL Server connection timeouts

For the last few days our clients have been suffering intermittent connection timeouts to our database server. Multiple Ajax calls on the same page which connect to the server multiple times are ...
2
votes
1answer
8k views

How to diagnose what is causing DB timeouts [closed]

I'm a web developer which currently has the joy of managing a client website that is still using Classic ASP that uses SQL Server 2000. The code is quite old and in the process of been updated to a ...
5
votes
1answer
13k views

Client times out, while MySQL query remains running?

We experienced an issue in which a read-only query, run through MySQL workbench, timed out from a user's UI perspective and remained running on the server (and apparently consuming more and more ...