Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [connectivity]

Establishing a connection to a database or database server.

376 questions
31
votes
6 answers

SQL Server compatibility with New TLS Standards

The major browsers are moving beyond SSL3.0 and TLS1.0 . The PCI Security Council has declared an end-of-life date for these protocols to be considered sufficiently strong encryption. We need to move away from these protocols, to use newer and…
Mark Goldfain
  • 413
  • 1
  • 4
  • 7
28
votes
5 answers

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 connecting Object Explorer or a new blank query…
Jordan Rieger
  • 401
  • 1
  • 5
  • 13
18
votes
3 answers

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

When right-clicking on a table and selecting "select top 1000 rows", I get this error: Is there any workaround, other than the obvious upgrade to SQL Server 2014?
Marcello Miorelli
  • 14,544
  • 46
  • 126
  • 249
15
votes
4 answers

The specified network name is no longer available

We have an application that access the database (Sql server 2014 enterprise edition). The application calls a stored procedures to access the database. Everything was working fine until recently start sending the following error and stop the…
Hailegziabher Dechassa
  • 836
  • 2
  • 7
  • 22
13
votes
7 answers

Remote MySQL connection fails (10060) - "Can't connect to MySQL server on domainname.com(10060)"

I have developed an application in VB6, and am using an online MySQL database server for storing my application's data. The first time I try to connect to my database server is successful, but after closing my application and starting it again I…
Ashok Gujjar
  • 243
  • 1
  • 2
  • 5
13
votes
3 answers

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 default timeout of 30 seconds in the web application and…
Craig Efrein
  • 9,418
  • 11
  • 53
  • 94
11
votes
12 answers

Error: Cannot Generate SSPI context

When someone tries to connect to a SQL Server instance, the error shows up: It's not possible do generate SSPI context. Yesterday we had a blackout (don't know how to say this expression in English) and I had to shut down our servers. Looking for…
Racer SQL
  • 7,004
  • 9
  • 49
  • 101
11
votes
5 answers

How to access a SQL Server database from other computer connected to the same workgroup?

I have created a C# application which uses a SQL Server database. I have other computers connected to me and to each other in a workgroup. I have shared my C# application with others. When they open the application they get the error A network…
ash
11
votes
1 answer

Connecting to a local MS SQL Server from a GUI client

I am very new to SQL and database servers. I have recently been using SQL Server Express and accessing my database using SQL Server Management Studio on Windows. I am now trying to achieve a similar setup on a Linux machine. I would like to create a…
KOB
  • 213
  • 2
  • 5
10
votes
1 answer

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 error message asking if I want to re-connect. This…
wiltomap
  • 317
  • 1
  • 2
  • 15
10
votes
2 answers

Domain Admins can't connect to SQL Server

I have a Windows Server 2012 R2 domain controller and a database server (W2K12R2/SQL Server 2012). As allowed usergroup I have given the group "domain-admins" sysadmin rights. But somehow any domain-administrator can't connect to that SQL Server,…
Erik Mandke
  • 361
  • 2
  • 4
  • 10
10
votes
1 answer

What's the differences between the two version of oracle client download file, "client" and "client home"?

I noticed the Oracle database download page has two groups of clients for users to download. There is a thing called "client" and has 32-bit version and 64-bit version. Also, there is a thing called "client home", which also has both 32-bit and…
Just a learner
  • 2,492
  • 5
  • 29
  • 46
9
votes
1 answer

Reconnect "not connected" query windows in SSMS to original connection

Is there a simple way to reconnect a query window that is "not connected" to the original connection that was used by that query without manually picking the server name needed? If I click the Connect button on the SQL Editor toolbar or right click…
David Hiltenbrand
  • 93
  • 1
  • 1
  • 6
9
votes
2 answers

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 resources) until we had an outage. Questions Is there…
asthasr
  • 223
  • 1
  • 2
  • 7
8
votes
1 answer

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 having mixes of success and failure, and at times…
Matthew O'Rourke
  • 81
  • 2
1
2 3
…
25 26