Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [connectivity]

Establishing a connection to a database or database server.

409 questions
71
votes
7 answers

Connect with sqlplus from the command line using a connection string

Let's say I have an Oracle database. I have a username = x, password = y, database = z, port = a, SID = b, and Hostname = c. So, how do I connect correctly? I used many options like: sqlplus…
Edvinas
  • 711
  • 1
  • 6
  • 3
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
31
votes
6 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
  • 471
  • 1
  • 6
  • 14
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
  • 17,274
  • 53
  • 180
  • 320
17
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
  • 856
  • 2
  • 8
  • 22
15
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,546
  • 16
  • 77
  • 140
15
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,082
  • 7
  • 36
  • 57
14
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
  • 253
  • 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…
user4659
11
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
  • 381
  • 2
  • 4
  • 10
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
2 answers

SQL Server Error while creating User

I tried creating a user with all privileges but I am getting this error: Microsoft SQL Server Management Studio Create failed for User 'Hru'. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL…
Hiral
  • 119
  • 1
  • 1
  • 3
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
11
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
  • 113
  • 1
  • 1
  • 7
11
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
  • 243
  • 1
  • 2
  • 8
1
2 3
…
27 28