Questions tagged [connectivity]
Establishing a connection to a database or database server.
370
questions
2
votes
1answer
50 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 ...
0
votes
0answers
55 views
psql connects to AWS RDS instance for co-worker, but not for me
We're on an EC2 VM (the same EC2 VM on the same subnet as the RDS instance) running vanilla PostgreSQL 12.5, and using psql to connect to an AWS RDS PostgreSQL 12.5 instance.
My co-worker and I run ...
0
votes
1answer
60 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 ...
1
vote
1answer
82 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 ...
0
votes
0answers
394 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 ...
0
votes
1answer
67 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 ...
0
votes
0answers
85 views
SSMS Object Explorer The semaphore timeout period has expired
I'm having an issue connecting to a remote instance in SSMS. When trying to connect using the Object Explorer I get the following error message.
A transport-level error has occurred when receiving ...
0
votes
1answer
162 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 ...
1
vote
0answers
23 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 ...
0
votes
0answers
35 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, ...
0
votes
0answers
107 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. ...
0
votes
0answers
88 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 ...
1
vote
0answers
183 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 ...
0
votes
1answer
12 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 ...
0
votes
1answer
496 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
vote
1answer
75 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 ...
0
votes
0answers
18 views
Trying to connect to DB2 through WinAutomation, which driver should I use?
I'm trying to connect to DB2 through winautomation, I haven't been able to make the connection by using the options below.
I'm using the following connection string format
Server=myAddress:...
1
vote
1answer
753 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({
...
0
votes
1answer
50 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 ...
0
votes
2answers
504 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) ...
1
vote
1answer
103 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 ...
0
votes
0answers
205 views
Mongo Atlas connection error type=UNKNOWN, state=CONNECTING
Yesterday I've seen some strange behavior that my application can't connect to Atlas.
This has never happened before for about 1 year, and there was no application deploying going on.
The error that ...
0
votes
0answers
55 views
Postgres: Allowed connections from any ip but still can't connect from Github Actions
I'm having some trouble setting my Postgres database to allow connections from all origins, specifically I can't seem to get my API to connect to it while running Github Actions for testing purposes.
...
0
votes
1answer
26 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
vote
1answer
543 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 ...
2
votes
2answers
363 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 ...
0
votes
0answers
18 views
mysql contacts wrong ip
I setup my MariaDB on my virtual machine and I can successfully connect to it locally.
I can ping the machine too. However, when I contact via the host machine, I do not understand why instead of 192....
0
votes
1answer
401 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 ...
0
votes
1answer
64 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 ...
0
votes
0answers
23 views
Unable to connect to AWS RDS Instance
This is the connectivity info:
And this is the configuration:
Public connection is allowed, vpc acl inbound:
What am I missing?
Edit: when I try to connect I get an error as if the endpoint is ...
6
votes
1answer
911 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 ...
0
votes
0answers
166 views
Remote access problem - PostgreSQL
I'm don't know much about database management, so to enable the remote access to my postgresql db I followed some tutorials. I've updated pg_hba_conf and postgresql_conf files.
In pg_hba_conf I added ...
0
votes
1answer
131 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 ...
0
votes
1answer
37 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.
...
1
vote
1answer
167 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
...
0
votes
1answer
521 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 ...
0
votes
0answers
41 views
Changing domain, can't connect [duplicate]
I have a server that hosts a SQL Server 2017 Entreprise Edition database. I changed domain on the server (e.g. attds.mg in fdsqq.mg).
The problem is that I can't connect my application to the database....
1
vote
0answers
2k views
"The client and server cannot communicate, because they do not possess a common algorithm" error
The full error message is:
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
1
vote
0answers
107 views
2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:
We are getting continuously logs in mysql error logs
2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets)
we ...
1
vote
1answer
456 views
Keep getting "Connected to an idle instance" in 18c when trying to connect to database
I installed Oracle Database 18c yesterday and then installed Oracle Application Express v20.1. Everything was perfect and I was able to work on Apex too.
Then I shutdown the computer and today I ...
1
vote
1answer
122 views
Lost SQL credentials and unable to connect to SQL via SQLCMD
I have a machine running SQL 2014 but have neither the windows authentication or sa authentication details due to mismanagement of a previous support team.
Having tried logging in to SQL Management ...
0
votes
1answer
271 views
ORA-12518 and then TNS-12560, TNS-00534 and 64-bit Windows Error: 10022: Unknow Error when trying to connect to a cdb or a pdb (Oracle 12cR1)
I am seeking for help for a problem I try to resolve for a whole week. As the title say, I try to connect to a pdb or cdb and specifically using the @ statement.
I created my instance named 'test', ...
0
votes
1answer
32 views
SQl connection to XAMP
i am trying to connect my database to XAMP . I got this error
Warning: Use of undefined constant ID - assumed 'ID' (this will throw an Error in a future version of PHP) in C:\xampp\htdocs\Thairis\...
0
votes
2answers
149 views
Getting Error 10054 after renaming the server
When I open SQL Server I have error 10054. Recently I changed the server name and I probably have this problem since. How can I solve it?
0
votes
1answer
113 views
The service broker is administratively disabled
I have just restored some databases what use service broker from LIVE to staging.
it is not working and when I put a profile trace to run it only shows messages related to database id 1 and 4, ...
0
votes
2answers
214 views
What happens if you lose the connection during a huge insert?
What happens when you lose your connection with the DB during a huge insert. Will part of the data be inserted? Will nothing be inserted? What is the reason for this?
The example statement I am ...
0
votes
2answers
155 views
pre login initialization =29237; handshake=26244
Connecting to one of my servers (no mirror or availability group running), from a local machine and I get this error message below related to handshake when the firewall is up.
when the firewall is ...
0
votes
1answer
265 views
I want to delete connections in tnsnames.ora. I need to figure out which ones are currently in use, so that I don't delete them mistakenly
I'm using Oracle 12c in Debian 8 (on a vm)
This question is for educational purposes only. I'm not using any production servers, so anything that you can tell me won't have consecuences
To start with,...
2
votes
2answers
233 views
One database listening on two database names
I know this is a sort of odd request. I myself have never had to even think about a scenario like this until today. I'll go straight to the point to make the question easy to read. I suspect the right ...
1
vote
1answer
333 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 ...
