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
0 votes
0 answers
22 views

pgadmin connection to server error

I'm having a server-connection-error on pgadmin dashboard. I kept having a connection timeout error after prompting me to enter the password for user "postgres" after clicking on PostgreSQL ...
4 votes
3 answers
1k views

Named instance throwing error 26 and won't connect

I've installed 3 new named SQL Server 2019 instances on a standalone server. The named install seems to have defaulted to computername\network name. Ex: BHMDB06\sseprod. During the install I had it ...
0 votes
1 answer
4k views

SQLSTATE[HY000] [2002] Connection refused when trying to initiate connection via Dockerfile's CMD

I'm trying to run a Docker container based on: PHP 8.1 Apache 2.4 MariaDB (latest official docker image) Dockerfile: FROM php:8.1-apache WORKDIR /var/www/html/ RUN pecl install xdebug \ &&...
0 votes
1 answer
28 views

SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting

I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers. I've narrowed down what I think my issue is. My cluster ...
0 votes
1 answer
4k views

Unable to connect with JDBC after MySQL upgrade from 5.7 to MySQL 8.0

We use java application client to transfer database table data to a third party server. With MySQL 5.7 it was working fine. After upgrade to MySQL 8, it started to show errors. First thing we did was ...
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 ...
0 votes
1 answer
217 views

How to investigate intermittent Postgres connection errors?

Our webserver (Django-app on Gunicorn running on Google Cloud Run) connects to a Postgres 15 database (on Google Cloud SQL) through Psycopg. Most queries are successful, but recently ~1% of the ...
3 votes
1 answer
2k views

SSMS cannot connect to SQL Server 2022 - Internal Error

I'm trying to connect (on the same host) from SSMS 19.0.2 to a newly installed SQL Server 2022 developer edition instance. I am getting a weird internal error: =================================== ...
0 votes
1 answer
381 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
1 vote
1 answer
857 views

Why changing the order of network protocols does not make any sense?

All I want to do is to connect to SQL Server though Named Pipes without using an explicit way like NP:ServerName because mentioned approach works. I want to connect through Named Pipes using just ...
0 votes
2 answers
47 views

database involved in availability group - showing state as online but it is synchronizing and does not accept connection - how can I find that out?

how can I find the list of databases I actually can connect to? I am using sys.master_files to check the state of my database files however, on the secondary, the database is synchronizing and it is ...
0 votes
1 answer
866 views

Oracle JDBC TLS connection fails (handshake_failure) after OS upgrade

I have an Oracle Database 12.1 server running on Oracle Linux 6. Secure (TLS) connections were working fine until I decided to update the underlying operating system (yum update) and reboot the ...
2 votes
1 answer
2k views

SQL Server Profiler - Client unable to establish connection

Spanking brand-new installations of: Visual Studio 2022 Community (VS) SQL Server 2019 Dev (SQL) SQL Server Management Studio v18.10 (SSMS) There are no other Visual Studio or SQL Server instances ...
0 votes
0 answers
14 views

OPC client trying to connect to OPC HDA server and end up in infinite waiting

I am quite new to OPC server/client. I have a service application serves as an OPC client, and trying to connect to OPC HDA server to data reading. There is a list of tags which their value at a ...
0 votes
0 answers
37 views

Need help to get a server to login to SQL Server database

I created a virtual machine (VM) on Azure to host Sparx Enterprise Architect cloud-based repositories using Pro Cloud Server (PCS) https://sparxsystems.com/products/procloudserver/30-min-tour/index....
1 vote
1 answer
3k views

The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount

I get the error message as appears in the title and seen below when running a query against one of our SQL databases. The error seems to be consistent with this specific query when trying to return ...
0 votes
3 answers
406 views

MySQL Query/Connect to eximstats?

I'm trying to run a report for my clients in real-time. I created a new eximstats user (renamed the old one) with: update mysql.user set password=password("XXXXXXXXX") where user="eximstats"; In ...
1 vote
2 answers
2k views

SQL Server connectivity without specifying tcp/port

Having connection issues out of nowhere in my lab (Azure VMs): SQL 2016, sp1, cu4 all the way around, Windows 2016 Datacenter Windows Failover cluster for SQL AG testing. SQLServer-0: Default ...
1 vote
2 answers
598 views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm ...
0 votes
0 answers
119 views

cant connect with secure connection to latest mysql server 8.0.36, error | MY-010914 | Server | Bad handshake

I upgraded from MySQL server 7 to latest 8.0.36 and now when I try to connect securely using the following command: mysql -u my_user -pxxxxxxxxx -h db-server.domain.com -P 3306 --verbose --protocol ...
0 votes
1 answer
2k views

Can't connect with UDL file to SQL Server 2016 but with SSMS it works without problems

I have a strange issue using a UDL file. I can't connect with the UDL file to SQL Server 2016 with a specific user (login) but when I'm trying to connect with the same user via SSMS, it works without ...
1 vote
1 answer
1k views

Connection rejected on MySQL server (error 10060)

I have a small database on a server in my LAN that I try to access remotely via ODBC. Currently, I am making a program in Visual Basic to access, retrieve and display data from the server to an Excel ...
2 votes
1 answer
2k views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
0 votes
1 answer
29 views

Connection Error when trying to connect to Azure SQL Database from a Virtual Machine

We're currently facing a connectivity issue while attempting to connect to the Azure database from our on-prem Virtual Machine (VM) through SQL Management Studio.Vm is hosted on ESXI. The VM ...
3 votes
2 answers
882 views

Do applications have to specify TCP: in the connection string to availability group listeners?

In articles that I have read about applications accessing databases through the availability group listener, they all seem to want to use TCP: prefix before the listener name in their connection ...
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 ...
2 votes
0 answers
34 views

MySQL Client taking more than 14 sec to be connected

IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
0 votes
0 answers
51 views

connection failed: FATAL: role "y" does not exist when .ini has role "x"

I have a Python program for PostgreSQL database management. Today it started throwing psycopg.OperationalError: connection failed: FATAL: role "role_a" does not exist Connection parameters ...
0 votes
1 answer
1k views

Cannot Connect (Internal connection fatal error. Error state: 15, Token : 23 (Microsoft.Data.SqlClient)

I had SQL Server 2019 Developer Edition installed and working correctly. Could access via SSMS without issue. About a month ago, I lost connection. Tried checking everything I could find online, no ...
1 vote
2 answers
92 views

Can't connect to named instance from remote server

I have researched a lot on this issue but can't seem to find a solution for it. I have a named instance created on a server but I can't connect using the Servername\InstanceName. I am using SQL ...
0 votes
1 answer
41 views

MySQL Drop Federated Table When Remote Server is Down

We have a production database (MySQL 8.0) that has a federated table in it. The remote server had an IP address update, and whenever a client opens this DB, it takes forever (~5 minutes) since table ...
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 ...
2 votes
2 answers
2k views

Connecting to SQL Server Named Instance Without Specifying Instance Name

I've been working with SQL Server and its instance types - default and named. My understanding has always been that to connect to a named instance, it's necessary to specify the instance name. However,...
0 votes
0 answers
100 views

Cannot connect to PostgreSQL DB over a Virtual IP (VIP)

I am running a PostgreSQL DB Server v12.16 on an Ubuntu 20.04 virtual machine. When I attempt to connect to DB directly from host, it WORKS! When I attempt to connect to DB via the VIP, it DOESN'T ...
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 ...
0 votes
1 answer
139 views

PostgreSQL to MS SQL Server bridge/gateway

We have an application that only supports PostgreSQL as a backend, but we have our whole infrastructure already setup with SQL Server, and we would like to keep using it instead of having new ...
0 votes
1 answer
2k views

Why my Oracle 12c database seems not to be started?

I have installed an Oracle 12c database on my development environment, which I start only once a while for integration testing. But today, it does not seem to start, or did it start but does not allow ...
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 ...
0 votes
0 answers
18 views

Is it possible to analyse session aborts from the Microsoft SQL Server side?

We see SQL session aborts on some clients. In most cases it is a real network problem (VPN/WLAN/Internet Connection). Is it possible to see any reason code on the server side, when a session aborts? I ...
1 vote
2 answers
6k views

Unable to login to SQL Server using SSMS and SQL agent failing

I have SQL Server 2008 R2 ENT insalled on Windows server 2008 R2 ENT. I am unable to login to SQL Server locally after the installation. Getting below error: Connection handshake failed. An OS call ...
0 votes
0 answers
44 views

Linked server failed

I'm trying to set up a linked server, but it still fails and gives an error: Error: Microsoft ODBC Driver 17 for SQL Server : SQL Server Network Interfaces: Error Locating Server/Instance Specified [...
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 ...
0 votes
0 answers
279 views

How to connect to a postgreSQL database hosted locally on my PC from google colab?

I'm trying to connect to a postgreSQL database on my PC from google colab. I'm using sqlalchemy to attempt this. I have a table named mdl_assign_grades which I'm trying to access. Here's my code: from ...
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 ...
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@'(...
3 votes
6 answers
49k views

MySql-Workbench: Can't connect to MySQL server on '127.0.0.1' (111)

The hard data first: Local machine: Xubuntu 17.10, with MySql-Workbench 6.3 Remote Machine: Ubuntu 16.04, with MySql-Client 5.7 and MySql-Server 5.7 The connection method is: Standard TCP/IP over ...
2 votes
1 answer
2k views

Can't connect to a remote server using phpMyAdmin

I tried with two different servers, one had no issue but the other gave me this error: MySQL said: Cannot connect: invalid settings. mysqli_real_connect(): The server requested authentication method ...
1 vote
2 answers
103 views

How is cassandra 9042 port used in the context of lsof command?

I am trying to identify who is making connection to cassandra instances in my environment. The machine has ip 172.31.44.23. I ran the command sudo lsof -i -n -P | grep 9042 | grep ESTABLISHED | awk ' ...
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&...
0 votes
2 answers
394 views

Oracle sqlplus doesn't connect to remote DB, only local

I would appriciate some help with an issue that I'm facing. I have two Oracle DB servers with same schemas. I want to run sqlplus from one server to another. I've added the tns_names entries in ...

1
2 3 4 5
9