Questions tagged [connectivity]
Establishing a connection to a database or database server.
377
questions
0
votes
0
answers
28
views
Why would one of our linux VMs have a lag in connecting to PostgreSQL and not the others?
We have several VMs connecting to multiple PostgreSQL database servers. All but one VM connect instantly to all of the database servers, while our newest VM sometimes has a noticeable (1-2 seconds) ...
- 15
1
vote
1
answer
108
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 ...
- 11
0
votes
1
answer
19
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 ...
1
vote
1
answer
20
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 ...
- 11
0
votes
0
answers
35
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 ...
- 101
3
votes
1
answer
668
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 ...
3
votes
1
answer
395
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' ...
- 55
0
votes
1
answer
1k
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 \
&&...
- 161
0
votes
1
answer
724
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 ...
- 13
0
votes
1
answer
35
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 ...
- 399
0
votes
1
answer
836
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 ...
- 173
0
votes
0
answers
71
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) ...
- 1
0
votes
0
answers
58
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 ...
- 133
0
votes
0
answers
157
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 ...
- 985
0
votes
1
answer
844
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 ...
- 173
0
votes
1
answer
48
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 ...
2
votes
1
answer
649
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 ...
- 21
1
vote
0
answers
133
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 ...
- 121
0
votes
0
answers
442
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:\...
- 1
0
votes
2
answers
790
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 ...
- 103
3
votes
3
answers
1k
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 ...
[...
- 563
2
votes
1
answer
2k
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 ...
- 12.7k
1
vote
1
answer
145
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 ...
- 123
0
votes
1
answer
446
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 ...
- 15
1
vote
1
answer
318
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 ...
- 127
0
votes
0
answers
2k
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 ...
- 1
0
votes
1
answer
628
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 ...
- 15.4k
1
vote
1
answer
2k
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 ...
- 201
1
vote
0
answers
54
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
0
votes
0
answers
41
views
SQL connections to java applications
I have an MSSQLServer2000 database that seems to have been working just fine until today. The DB connects to a java application on a remote server that passes the database data (login credentials, ...
- 75
0
votes
0
answers
783
views
SQLSTATE[HY000] [2002] Connection refused with multiple connections
I am using Laravel 8.33.1 and mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) on my Ubuntu 20.04.1 LTS vps.
As during development I also need to access data from my production db. ...
- 135
0
votes
0
answers
392
views
PostgreSQL remote connection failing
I've recently installed PostgreSQL on my PC as a requirement for my DB class, and as a practice, I decided to try and setup a remote connection for it so I can access it via online services. But after ...
- 31
1
vote
0
answers
1k
views
How to configure the client certificate in Power BI desktop to authenticate with mutual TLS
I am trying to connect to a private data source from Power BI desktop. Data source has its own trusted root authority. I created my personal certificate and private key signed by this root CA. I ...
- 11
-1
votes
1
answer
270
views
Database not showing
I create a database in the terminal linux ubuntu,gave it all privileges,created the table,inserted the rows.When I open phpmyadmin the database isn't showing how do I connect them?
I did use mysql -u ...
- 1
1
vote
1
answer
3k
views
Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?
The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4.
Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
- 1,437
1
vote
2
answers
353
views
How to script server level objects in sql server?
I regularly do sql server installations (mainly sql server 2016), in virtual machines or otherwise, and I have a bunch of things like permissions, and linked servers and endpoints that I have mostly ...
- 15.4k
2
votes
1
answer
9k
views
Not authorized on test to execute command
Here is my code:
mongoose.connect(consts.database, {
useNewUrlParser: true,
useUnifiedTopology: true,
sslCA: consts.databaseCert,
});
//...
const user = await db.userModel.findOne({
...
- 151
0
votes
1
answer
56
views
Trying to connect two SQL Server databases
I have been trying to connect to a SQL Server instance. When I use the IP address, it connects. But when I use the server name, it doesn't. The main reason why I need to use the name is because I want ...
- 51
1
vote
2
answers
2k
views
The listener supports no services - 2 databases on oracle linux 7
I'm running two 12c R2 databases on linux oracle 7.9
I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
- 13
1
vote
1
answer
325
views
SQL Native Client Upgrade
Application server for CRM has SQL native client 2008 version installed. I have installed SQL native client 2012 side by side as need to connect to an sql availability group listener. How do I get the ...
- 11
0
votes
1
answer
70
views
MV on remote/master table fails to resume syncing (after master db host was temporarily unreachable)
I have a fast-refresh materialized view in a target db (18c) that syncs from a remote table/master db (19c):
--master db (19c)
create materialized view log on master.workorder with primary key;
--...
- 1,417
1
vote
1
answer
2k
views
Query to Linked Server Ignores Configured Timeout Connection
I need to know where to set the timeout for a login or a query to a linked server. If the server is down I don't want to waste too much time waiting for a timeout. (Our servers are on the same network ...
- 61
2
votes
2
answers
2k
views
SQL Server Connection Problem
I'm completely stuck on a connection problem that we're experiencing for users connecting to our SQL Server instance from a particular domain using a particular application. The error that we're ...
- 121
0
votes
1
answer
1k
views
The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted
One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes.
End users are getting some error in the application that always point to the same error ...
- 127
0
votes
1
answer
103
views
MariaDB (RDS) going temporarily offline (with memory drop)
We have an issue with a database of ours on RDS running MariaDB 10.4.8 on a t3-large instance type.
For the past week or so, it's been sporadically inaccessible with no errors I can find. During the ...
- 113
9
votes
1
answer
3k
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 ...
- 93
0
votes
1
answer
304
views
SQL Server Ubuntu server - failure: remote connection from Win 7
Our analytical lab (chemistry) has an information management system (LIMS) that uses a Microsoft SQL Server database. Technicians interact with the system through a Windows form application that is ...
- 11
0
votes
1
answer
104
views
Unknown source of high number of connections
In MySQL/Aurora I see from time to time a spike in connections number (from about 100 to 4000):
MySQL doc says:
Connections
The number of connection attempts (successful or not) to the MySQL server.
...
- 473
2
votes
1
answer
698
views
How to save database connection information when using `psql`?
I am learning to use psql to work with a postgres database on linux.
I can connect using a long connection string, for example by running:
psql postgresql://myusername:mypassword@localhost:5433/dbname
...
- 153
2
votes
1
answer
4k
views
how do I prevent my postgres connection from timing out? (python, psycopg2)
very quick one from me: I have a python script that runs continuously, keeping an eye on a postgres database. I've set up a listening channel and everytime a relevant change is made, the script gets a ...
- 183