Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
0
votes
1answer
12 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
39 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
41 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
37 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
28 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
71 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
60 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
8 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
68 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
39 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
105 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
60 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
84 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
168 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
148 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
73 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
368 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
403 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
269 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
85 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
86 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
524 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
39 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
703 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
90 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
0answers
201 views

We have 2 SQL server 2016 servers that are having communication issues

We have 2 SQL server 2016 servers that are having communication issues when setting up Availability groups and replication. The servers can ping each other and can be connected using a UDL file and an ...
0
votes
1answer
351 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
226 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
257 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
109 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
200 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
568 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
922 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 ...
6
votes
1answer
7k views

What's the differences between the two version of oracle client download file, “client” and “client home”?

I noticed the Oracle database download page has two groups of clients for users to download. There is a thing called "client" and has 32-bit version and 64-bit version. Also, there is a thing called "...
0
votes
0answers
29 views

LibreOffice Base Brings in all visible databases as list of tables

I'm trying to connect to a singer database through LibreOffice Base. The connection goes fine and successful. However, when selecting tables, it's showing a list of all the visible Databases in the ...
-3
votes
1answer
1k views

The login is from an untrusted domain and cannot be used with Windows authentication

I am facing this issue after trying to run a Windows application on sharing client side in a workgroup environment, while this application working on server machine fine.
0
votes
1answer
72 views

differences in the authentication scheme - could it be because of Kerberos?

I am using this script to check the connections to my sql server: select C.client_net_address, S.host_name, c.session_id, c.net_transport, c.protocol_type, c.auth_scheme, s.program_name from sys....
0
votes
1answer
45 views

Unable to create maintenance plan

When trying to create a maintenance plan locally on two prod servers through SSMS, I receive this error: No such error occurs on my UAT system. They're all running SQL Server 2017 (14.0.3162.1), and ...
1
vote
1answer
1k views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
0
votes
0answers
46 views

SQL Server DAC - Connection Issue

I am having a strange issue when trying to connect to my SQL Server instance remotely from my client computer. I am able to do this on my other instances by opening up a new Database Engine Query and ...
1
vote
1answer
136 views

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers, SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below: select distinct rcs.database_name, ar....
0
votes
1answer
319 views

Cannot connect to MySQL using PHP 7 [duplicate]

The version of MySQL is 8.0.16. This is installed on an EC2 Linux and is a fresh install. I have run the mysql_secure_installation command after installation and was able to change the root password ...
0
votes
1answer
32 views

when is it necessary to create aliases in the SQL Configuration Manager?

I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager I see there are aliases. I was wonder why ...
0
votes
0answers
2k views

How to resolve an SQL Server “Target principal name is incorrect” error invoked after upgrading from SQL Server 2016 to 2017?

I am experiencing a "Target principal name is incorrect" error after upgrading SQL Server 2016 to 2017. The SQL Server 2016 instance has been uninstalled. The certificate which is registered in SQL ...
0
votes
1answer
337 views

Connect to another host from inside mysql stored procedure

I have two virtual servers on one physical machine. There are MySQL users and passwords the same for both of them. I want to write something like this: SELECT * FROM [host_name].[db_name].[...
1
vote
0answers
101 views

sqlplus connection to Oracle 11g takes much more time to establish than from another machine

I have an existing Ubuntu 16.04LTS 64bit system that connects to Oracle 11g (11.2.0.4.0 64bit/Windows). From that Linux machine I can connect to Oracle via sqlplus instantly, using sqlplus uid/pwd@...
0
votes
0answers
556 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 ...

1
2 3 4 5
7