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
1 answer
25 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 ...
Mr. Berzerk's user avatar
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 ...
Marcello Miorelli's user avatar
0 votes
0 answers
12 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 ...
Zhang yy's user avatar
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....
sys_eng's user avatar
0 votes
0 answers
108 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 ...
Jon Simson's user avatar
0 votes
1 answer
190 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 ...
Koen De Wit's user avatar
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 ...
sam john's user avatar
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 ...
Basudev Rout's user avatar
0 votes
0 answers
47 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 ...
jvkloc's user avatar
  • 133
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 ...
jsp's user avatar
  • 1
1 vote
2 answers
90 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 ...
kaitlyn's user avatar
  • 573
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 ...
MadHatter's user avatar
  • 101
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,...
Fajela Tajkiya's user avatar
0 votes
0 answers
93 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 ...
user3051574's user avatar
0 votes
1 answer
133 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 ...
golimar's user avatar
  • 112
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 ...
xMRi's user avatar
  • 230
0 votes
0 answers
43 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 [...
Jan Kůst's user avatar
0 votes
0 answers
268 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 ...
Bruce Murdock's user avatar
1 vote
2 answers
102 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 ' ...
randominstanceOfLivingThing's user avatar
4 votes
3 answers
977 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 ...
bwilliamson's user avatar
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: =================================== ...
mikb's user avatar
  • 131
0 votes
2 answers
386 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 ...
IGOR LEVKOVSKY's user avatar
1 vote
0 answers
79 views

Windows authentication on remote client accessing SQL Server 2022 with SSMS [duplicate]

I have installed SQL Server 2022 on Windows Server 2019 Datacenter, and applied the March SQL Server 2022 Cumulative Updates. Also installed on the server is SSMS 18.12.1 and 19.0.2. On a remote ...
K Harrison's user avatar
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 ...
SuperRamen's user avatar
0 votes
1 answer
143 views

How to change user-agent/application name when connect to PostgreSQL?

I use AWS RDS, and there is top application tab in perfomance insight like below sceenshot TablePlus is a SQL client that I used. If I run query using that app, it shows TablePlus in that tab. But if ...
Muhammad Dyas Yaskur's user avatar
1 vote
1 answer
42 views

What happens if you cancel a job with multiple statements?

If I have a SQL script with multiple Update statements in series. What happens if query device goes offline after completing half the Update Statements? Does it rollback the currently executed Update ...
ADMKE's user avatar
  • 11
0 votes
0 answers
44 views

One of 2 domain servers went down and now I can't connect to SQL Server on the other

I have: 2 AD Domain controllers - one running Windows Server 2008r2 and the other Windows Server 2016. FSMO roles are all on the Windows Server 2008r2 Windows Server 2016 is only online during a ...
billpennock's user avatar
3 votes
1 answer
5k views

cannot connect to SQL Server using local 127.0.0.1 address unless the login user has sysadmin role

problem i am trying to connect to the server using Microsoft ODBC Driver 17 for SQL Server through sqlcmd setting the -S (server) option pointing at 127.0.0.1,1434. i have confirmed this is the ...
microsoftvamp's user avatar
3 votes
1 answer
4k views

MariaDB Aborted connection events

A windows server (2022) has MariaDB 10.4 running on it. In the Event Viewer for Windows logs > Application there are two events that happen every minute: Aborted connection ### to db: 'unconnected' ...
td48260's user avatar
  • 55
0 votes
1 answer
3k 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 \ &&...
DevelJoe's user avatar
  • 163
0 votes
1 answer
3k 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 ...
Amit Sedai's user avatar
0 votes
1 answer
181 views

Universal Data Link Does not have MFA Option on Windows 10/11

In looking at the documentation Universal Data Link (UDL) configuration (V2022/2019 & 2016), it says I can use a UDL file to attempt an Active Directory - Universal with MFA support: type login ...
ΩmegaMan's user avatar
  • 409
0 votes
1 answer
3k views

DBeaver error returned connecting to Db2 database using SSL/TLS with hostname validation error

I have configured SSL/TLS on Db2/Linux v11.5.7.0. In DBeaver 22.1.5 (Java GUI program to access database) in Driver properties I have configured parameter: sslConnection to true and DBeaver ...
folow's user avatar
  • 339
0 votes
0 answers
113 views

Connection Error while connecting SQL Server from KNIME using SQL Server connector in KNIME

We are trying to connect KNIME to SQL SErver, but getting an error : Can someone help with the fix for this. Error : Establish a secure connection to SQL Server by using Secure socket layer (SSL) ...
Naren's user avatar
  • 1
0 votes
0 answers
127 views

How to connect to Oracle 9i through SSH tunnel if TNS protocol issues a REDIRECT to a random port?

Inspecting packets exchanged between SQLDeveloper and Oracle 9i I noticed that, in the beginning of the connection negotiation, the server issues a REDIRECT back to the client, pointing a port ...
Gustavo's user avatar
  • 163
0 votes
0 answers
262 views

How do I connect to mysql database with password

Using PHP 7.4.27 (now using 7.4.29) with MariaDB in xampp I can access everything using phpmyadmin. I am using the following on my localhost $con = new mysqli($host, $user, $pwd, $db); I can connect ...
Rohit Gupta's user avatar
  • 1,660
0 votes
1 answer
2k views

Can NOT establish connection from db2 client to db2 server v11.5

I installed Db2 v11.5.7.0 on Linux/x86_64 inside my virtual PC using VirtualBox on Windows 10. I created database with name TEST1 I connected to database using Unix socket: db2 connect to TEST1 and ...
folow's user avatar
  • 339
0 votes
1 answer
86 views

XE ucs package events

Can anybody explain for what purposes exists ucs package {C0AB75C5-B1EA-445B-B7DF-F897686F94E7} "Extended events for Unified Communications Stack" I have tried to catch some events like ...
solovyevuv's user avatar
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 ...
David Rogers's user avatar
1 vote
0 answers
321 views

Windows Suspending PostgreSQL Process

Scenario: Customer’s system VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors) PostgreSQL starts and runs fine for 5 minutes - 2 ...
StillLearnin's user avatar
0 votes
0 answers
1k views

sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor, and restart oracleSersvice XE not working for me

I have been confused for a few days; I tried many ways but they did not work. Here are my tnsnames.ora and listener.ora. please help me out. tnsnames.ora: # tnsnames.ora Network Configuration File: C:\...
picklman's user avatar
0 votes
2 answers
2k views

How to connect to Oracle RAC from HOST

For a college project, I have to set up a RAC Instance and an application, I already managed to configure my RAC lab by using virtual machines by using this video guide, now I just need to program an ...
Jeremy's user avatar
  • 103
3 votes
3 answers
2k views

Can connect to virtual MySql instance using 127.0.0.1, but not localhost

Running MySql 5.7.33 on a local VirtualBox instance. I have forwarded port 3306 from the virtual server to be accessible locally. On my virtual host, I have this in my /etc/mysql/my.cnf file ... [...
Dave's user avatar
  • 703
2 votes
1 answer
3k views

How can I change the RSA key length from 1024 to 2048?

SQL Server Environment: OS version: Windows 2012 R2 Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) Instance type: Named instance When I am attempting to connect from a Docker ...
SqlWorldWide's user avatar
  • 13.2k
2 votes
1 answer
349 views

Official documentation for all connection string parameters

I've been hunting for this information for years now but I don't seem to be able to find it: Is there any documentation available on learn.microsoft.com providing a table with all valid connection ...
AxD's user avatar
  • 133
0 votes
1 answer
984 views

Remote computer can't connect to instance with backslash

We are migrating two instances of SQL Server 2008 on a Win7 machine to SQL Server 2019 on a Win10 server. The old server had two instances: 123.123.123.123 and 123.123.123.123\ABC. We had no ...
Koughdur's user avatar
1 vote
1 answer
675 views

Cannot connect to remote instance

I try to connect to a remote windows server that has a SQL Instance running using SQL Authentication via my local SSMS and this the error I get: Cannot connect to 123.123.123.123\WIN-ODF1AGSBGZ A ...
Offir's user avatar
  • 127
0 votes
0 answers
3k views

PostgreSQL 'server closed the connection unexpectedly' when using the hostname (Azure VM)

I have a Postgres instance running on an Azure VM, which is inside an Azure Virtual Network, and the VM has a hostname. Connecting with PostgreSQL using the IP address works, but when I try to ...
YusufD's user avatar
  • 1
0 votes
1 answer
1k views

Linked server only works if I am on the machine itself. I can't use it from my local computer. what is missing?

I have a few queries that I use to monitor log shipping. Sometimes I want to run those queries on a different server. I usually do that through a linked server. I have a server called SQLDEV4-TS that ...
Marcello Miorelli's user avatar
2 votes
1 answer
4k views

Are postgres connection able to manage multiple requests at the same time?

I have an application using node Postgres driver to connect to my Postgres 12. The pool size is currently 1. Is it possible, for one connection, to have multiple requests sent before receiving the ...
Slim's user avatar
  • 249

1
2 3 4 5
9