Questions tagged [connectivity]
Establishing a connection to a database or database server.
348
questions
0
votes
0answers
22 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.
...
-1
votes
1answer
29 views
Oracle: Cannot connect to the database using DbForge or any other client, but can use SQL*Plus when I SSH [closed]
I am unable to connect to my DB using a client like Toad or DbForge but I am able to use the database when I SSH into the server and do SQL*Plus
Do I need to enable something like a service or ...
0
votes
1answer
12 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
77 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
88 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
14 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
54 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
52 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
16 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 ...
3
votes
1answer
156 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
24 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
45 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
28 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
25 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
0answers
15 views
MySQL and MariaDB both hanging up with any driver when connecting from a remote client to my VPS
What I did:
1- Changed the bind-address to 0.0.0.0. It didn't work. Then I commented it out. It didn't work.
2- Enabled and disabled skip-networking to no avail.
3- My users are using native password. ...
0
votes
1answer
51 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
40 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
310 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
55 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
96 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
77 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
120 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
9 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
82 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
58 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
141 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
74 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
121 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
175 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
199 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
1answer
86 views
Keyword not supported: 'statslog_on'
I am trying to connect to a SQL 2017 instance via SSMS 18.2 with the 'Additional Connection Parameters'
StatsLog_On=Yes;StatsLogFile=C:\Temp\TestODBC.txt
The documentation at Using Connection String ...
7
votes
1answer
3k 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 ...
3
votes
1answer
462 views
How to set IP segment and connection string with IPv6?
For this PostgreSQL configuration example:
https://repmgr.org/docs/4.4/quickstart-authentication.html
local replication repmgr trust
host replication ...
2
votes
3answers
558 views
“Network-related or instance-specific error” while attempting connect to a SQL Server on remote computer on home network
I have two laptops (both running Windows 10, 64-bit) connected to my home network using wifi. Here are details about each laptop (please ask if you need more info):
Laptop #1
2017 Microsoft SQL ...
1
vote
0answers
340 views
database mirror - A connection attempt failed because the connected party did not properly respond after a period of time
I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs:
--Execute it on Primary/Secondary server
EXEC ...
0
votes
1answer
127 views
Unable to connect to oracle user
I have hit a rather frustrating snag in that after installing Oracle 18c.
I have been unable to successfully create a user and then connect to it.
More precisely I can create the user but the ...
0
votes
1answer
96 views
MySQL Connection Error for TDV
I am trying to connect to a MySQL database using Tibco Data Virtualization Studio (TDV).
I was able to connect to the database using MySQLWorkbench. I checked my.cnf and skip-networking is not ...
2
votes
1answer
697 views
Can't Connect to MySQL database through PuTTY
I have a database that runs on pythonanywhere.com, and am trying to connect Tableau to it, and need to set up an SSH Tunnel in order to do so.
The directions on pythonanywhere's website mention ...
1
vote
0answers
40 views
SSMS Connect to remote SQL instance with Windows Authentication
I have a remote SQL instance
(Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64)
I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
4
votes
2answers
823 views
SQL Server trusted connection additional security
Using Windows authentication, is there a way to prohibit users from connecting via ODBC to the database?
1
vote
1answer
131 views
How To Access My PostgreSQL Server From Another PC Securely?
I want to be able to connect from any PC anywhere to my Database.
Host
OS: Windows 10
PostgreSQL: 12.0
Currently all Tutorials say the same: (Thats what i also did)
Change listen_addresses to ...
0
votes
1answer
435 views
I am trying to connect My R studio to SQL Database on the Remote Desktop
The SQL Server on the remote desktop is configured to have neither login nor password, it is configured to use Windows Authentication.
Code
I am using the following code to connect:
library(DBI)
...
1
vote
0answers
369 views
Aborted connections (Erros reading communication packets)
I set up a new Database Server over a SQL Dump with innoDB MYSQL 5.7 from MYSQL 5.6. The Server running external with many sleeping SMTP connections over 1 Mio a day. I made the server open for ...
1
vote
1answer
428 views
Connection to PostgreSQL disconnects every hour regardless of activity
I'm monitoring my PostgreSQL clients using a periodic netstat -an | grep 5432 | grep EST to check the ESTABLISHED status of the connection every 5 minutes. I have noticed that all of the connections ...
0
votes
0answers
139 views
PostgreSQL 10 not allowing remote connection
I cant get a PostgreSQL 10 instance to allow remote connections.
The database is hosted on Ubuntu 18.04
listen_addresses has been set to both '*' and 'myactualip' that needs to connect to the ...
5
votes
1answer
2k 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 ...
5
votes
1answer
256 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 ...
0
votes
1answer
680 views
I cannot get my data source to connect to an SQL Server named instance using SSRS Report Builder
I have a report in SSRS and I want to update the data source to use a named instance instead of the default instance. The server host will remain the same.
I thought this would be easy. I simply ...
1
vote
0answers
21 views
Impact of changing server machines names with SQL Server 2016 Standard in mirror state
It's an enterprise network domain.
Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
0
votes
1answer
1k views
Oracle user password with space character in it
I connected to an Oracle 19c database and executed the following SQL:
alter user sys identified by "a b" container=all;
It executed successfully. However, after that I can't connect to Oracle using ...
