Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
69 votes
7 answers
853k views

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 x/y@'(...
Edvinas's user avatar
  • 691
31 votes
6 answers
39k views

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 ...
Mark Goldfain's user avatar
30 votes
6 answers
53k 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 ...
Jordan Rieger's user avatar
18 votes
3 answers
56k views

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's user avatar
17 votes
5 answers
90k views

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 ...
Hailegziabher Dechassa's user avatar
15 votes
12 answers
186k views

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 ...
Racer SQL's user avatar
  • 7,386
14 votes
1 answer
33k views

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 "...
Just a learner's user avatar
14 votes
7 answers
183k views

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 ...
Ashok Gujjar's user avatar
13 votes
3 answers
30k 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 ...
Craig Efrein's user avatar
  • 9,640
11 votes
1 answer
16k views

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 ...
David Hiltenbrand's user avatar
11 votes
5 answers
159k views

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 ...
user avatar
11 votes
2 answers
41k views

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-...
Erik Mandke's user avatar
11 votes
2 answers
44k 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 ...
asthasr's user avatar
  • 243
11 votes
1 answer
4k views

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 ...
KOB's user avatar
  • 213
10 votes
2 answers
38k views

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 ...
Hiral's user avatar
  • 109
10 votes
4 answers
190k views

SYSDBA password in Oracle DB

I am connecting to Oracle DB with: sqlplus / as sysdba What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working ...
user2065083's user avatar
10 votes
1 answer
5k views

PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?

Even though it might sound related to this question, it isn't, because I'm intreseted in the use of unix sockets instead of TCP/IP ones. However, I am unable to connect to a remote PostgreSQL database ...
Migsi's user avatar
  • 103
10 votes
1 answer
31k 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 ...
wiltomap's user avatar
  • 317
8 votes
1 answer
8k views

Does SSMS use ODBC?

I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances. I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes ...
James Jenkins's user avatar
8 votes
3 answers
19k views

"login failed for user " on SQL Azure from azure hosted web application

I have an Azure ASP.net MVC web application which uses a SQL Azure db. It was working fine for some months (someday for some reason Azure changed the name of the server and I had to set that again but ...
Ricker Silva's user avatar
8 votes
4 answers
46k views

SQL Server access issue

I am trying to connect 3 SQL servers using SSMS from a different landing server. The issue is I am able to connect 1 server but unable to connect other 2. The error I get is below: A connection was ...
SQLPRODDBA's user avatar
  • 1,908
8 votes
4 answers
41k views

The connection is broken and recovery is not possible - sql server error

I am having the following sql server error, while creating tempDB files. Any ideas? The connection is broken and recovery is not possible. The client driver attempted to recover the connection ...
Marcello Miorelli's user avatar
8 votes
1 answer
4k views

What are valid connection strings for SSMS login box?

What are valid connection strings for SSMS login box? Every once in a while I will have to connect to an instance of SQL Server with some specific configuration setting or in a DMZ where no host ...
John K. N.'s user avatar
  • 17.9k
8 votes
2 answers
9k views

Classic ASP Connection to SQL Server 2014 without TLS 1.0 using ADODB.Connection

With TLS 1.0 being disabled in the name of PCI compliance, I'm unable to get a 32-bit Classic ASP application working. Per MS / Stack Exchange recommendations, I've installed: SQL Server 2014 SP1 ...
userx's user avatar
  • 131
8 votes
1 answer
2k 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 ...
Matthew O'Rourke's user avatar
7 votes
1 answer
50k views

Connect to SQL Server over Internet

I want to connect to SQL Server via Internet: I turned off the firewall I enabled the the DMZ in the router, host address is 192.168.1.24 which is the SQL Server LAN IP I open port in the router for ...
salbenny's user avatar
7 votes
3 answers
100k views

Cannot connect to my local instance

When I connect to my local server, I get this message A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not ...
zey's user avatar
  • 283
7 votes
3 answers
4k views

Can't connect to SQL Server 2017 Local DB shared instance

I cannot connect to a SQL Server 2017 (14.0.1000.169) Local DB shared instance. I tried on a laptop that previously had some SQL Server Express and stuff that I all have uninstalled. And also on a ...
Leojet's user avatar
  • 73
7 votes
2 answers
27k views

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee ...
joanolo's user avatar
  • 13.5k
7 votes
3 answers
20k views

Disabled SSL on SQL Server, now connection fails

I have a customer that is worried about the latest SSL vulnerability POODLE. They have a utility (IIS Crypto 1.4) that disables SSL 2.0-3.0 on the servers they run it on. They have disabled SSL on ...
Mike_G's user avatar
  • 171
7 votes
1 answer
24k views

Connection AlwaysOn AG Listener Problem

I'm a newbie for microsoft technologies and I'm having problems in connectivity part for SQL Server 2014. This is probably an easy issue but I'm stuck. I've 4 servers. One of them is the Active ...
erdimeola's user avatar
7 votes
0 answers
214 views

SQL Server 2012 Compatibility with New TLS 1.2 Standards [duplicate]

I'm trying to switch off TLS 1.0 on my SQL Server 2012 server in order to comply with PCI standards. Initially I had some trouble with the SQL Server service not starting. I found help for this ...
Chris C's user avatar
  • 71
6 votes
2 answers
3k views

What are all the ways an open transaction will rollback?

When a transaction is opened in SQL Server, what are all of the ways that it can be rolled back? We are currently working with a 3rd party application that is frequently showing open transactions ...
SomeGuy's user avatar
  • 2,013
6 votes
1 answer
6k views

Cannot connect Power BI Desktop to Azure SQL!

I'm trying to connect Power BI Desktop to Azure SQL, but I get "We couldn't authenticate with the credentials provided. Please try again." it works fine if I try from Microsoft SQL Server Management ...
Data-Base's user avatar
  • 357
6 votes
1 answer
2k views

how to stop using sql server login credentials in a linked server?

I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1 we are on different but trusted domains. The connection from server_italia to ORDB1 is made ...
Marcello Miorelli's user avatar
6 votes
1 answer
11k views

Adding a local user account into SQL Server

I have a (developer) instance of SQL Server 2014 running in my machine. For quick background I'm on a small network like this: Workgroup: HOME Users HOME\PCA HOME\PCB HOME\PCC I'm HOME\PCA. Now I ...
e1445's user avatar
  • 63
6 votes
5 answers
41k views

Can't connect to remote SQL server from some machines

Our web server uses SQL Server 2008 R2. I have one development machine that connects to it with the IP address through SSMS and when testing my aspx website. I have several other machines though that ...
David Kroll's user avatar
6 votes
1 answer
3k 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 never got to see the return value of the ...
Matthew Haworth's user avatar
6 votes
1 answer
35k views

How do I troubleshoot error 26: "Error Locating Server/Instance Specified"

I'm trying to configure TCP access to my SQL Server named instance (named SQL2012). I use management studio to connect to the database engine. I type in the server name: "tcp:localhost\SQL2012&...
Michael J Swart's user avatar
6 votes
1 answer
8k views

Connection Timeout Expired without apparent network issue

We have one particular SQL Server which is intermittently timing out when accepting connections. The issue is consistent throughout the day, but occurs at a very low incidence. How can I continue to ...
Mitch's user avatar
  • 2,638
6 votes
1 answer
31k views

Connection Reset by Peer: Socket Write Error

We have a vendor working on Java (JDBC) application saying they are getting the error Connection Reset by Peer: Socket Write Error They are insisting that the SQL Server (SQL Server 2012) is ...
SomeGuy's user avatar
  • 2,013
6 votes
1 answer
17k 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 ...
Yasin's user avatar
  • 193
5 votes
1 answer
1k views

Static DAC ports for named instances

Using SQL 2016 Enterprise Edition The default instance will listen on 1433 and the DAC port will listen on TCP 1434. SQL Browser will listen on UDP 1434. Any subsequent named instances will get a ...
Gavin Harris's user avatar
5 votes
1 answer
3k views

SQL Server on Ubuntu - An existing connection was forcibly closed by the remote host after reboot

I have been running SQL Server on Ubuntu for a while and everything has been working fine but I rebooted the server and now all connections to SQL Server fail with the error: A connection was ...
Robin Wilson's user avatar
5 votes
2 answers
13k views

Using SQL Server SMO with a Port number

In SSMS if you are connecting to SQL Server instance set to specific port other than 1433 you simply put ",port number" after the instance name. In the same regard if I am using System.Data.SqlClient....
user avatar
5 votes
2 answers
44k views

How to connect an oracle DB with MySQL workbench?

I am a bit confused: I want to connect an Oracle DB with the application "MySQL Workbench". In order its from Oracle as well I throught that this is possible. But until now Im not able to do so. With ...
Mario's user avatar
  • 161
5 votes
1 answer
1k views

SQL Server 2016 Availability Groups Named Pipes?

We have a SQL Server 2016 cluster configured (two VM's) with our databases spread across multiple Availability Groups (AG). Our Sharepoint admin is reporting to me that some functionality is failing ...
mhouston100's user avatar
5 votes
2 answers
16k views

SQL Server Named Instance is not listening on Port 1434

We just installed SQL Server 2016 on a Windows 2016 server. I am having issues connecting to the Named Instance of that server. I have noticed that the server isn't listening on port 1434 either. ...
kaitlyn's user avatar
  • 583
5 votes
2 answers
34k views

How to install SSIS on SQL Server 2014?

I am installing SQL Server 2014, including SSIS, on a Windows Server 2012 R2 machine. From this link: https://msdn.microsoft.com/en-us/library/ms137861(v=sql.120).aspx ssis uses port 135 which should ...
Marcello Miorelli's user avatar
5 votes
2 answers
27k views

ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS

I am using Toad to connect my database and its working fine for me . But when i try to connect with the same credential , i am getting the error message as shown below: ORA-12154 TNS: could not ...
Gaurav Soni's user avatar

1
2 3 4 5
9