Questions tagged [connectivity]
Establishing a connection to a database or database server.
406
questions
3
votes
0
answers
114
views
Troubleshooting error 17830 with various states
I have a SQL Server 2019 instance (build 15.0.4365.2. (CU26)) that is continuously seeing severity 20 errors with error number 17830. The state values vary, mostly state 11, sometimes we see state ...
- 70.3k
0
votes
1
answer
127
views
Operating system error 1326(The user name or password is incorrect)
I have been working with mapping drives inside sql server.
I mapped something similar to this:
EXEC XP_CMDSHELL 'net use y: "\\my_server\Initialed Folders\MM" @@__password__@@ /User:...
- 16.4k
0
votes
0
answers
38
views
App cannot connect to SQL instance though SSMS can
I'm getting the below error message when attempting to connect to an SQL Server hosted on an Azure VM.
Network error code 0x2746 occurred while establishing a connection; the connection has been ...
- 23
0
votes
1
answer
61
views
sql server client network utility - how to list the aliases?
there is something called sql server client network utility
it lives on
C:\Windows\System32 for 64 bits.
as you can see I have many aliases there, server, instance and ip address and port used for ...
- 16.4k
0
votes
1
answer
319
views
Failed to open the explicit specified database
When our application tries to connect to the Availability Group Database, we get the following error message on the primary replica:
Login failed for user 'xxx'. Reason: Failed to open the explicitly ...
- 373
0
votes
1
answer
297
views
Why does "Work Offline" turn itself on in SSIS?
I have an SSIS package that is currently working perfectly on my server. Whenever I open it in Visual Studio, "Work Offline" turns itself on for two of the SQL connections. This produces ...
- 685
0
votes
0
answers
111
views
pgadmin connection to server error
I'm having a server-connection-error on pgadmin dashboard. I kept having a connection timeout error after prompting me to enter the password for user "postgres" after clicking on PostgreSQL ...
0
votes
1
answer
71
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 ...
0
votes
2
answers
103
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 ...
- 16.4k
0
votes
0
answers
23
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 ...
- 1
0
votes
0
answers
40
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....
- 1
0
votes
0
answers
201
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 ...
0
votes
1
answer
528
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 ...
- 111
0
votes
1
answer
41
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 ...
- 1
2
votes
0
answers
35
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 ...
- 21
0
votes
0
answers
88
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 ...
- 133
0
votes
1
answer
2k
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 ...
- 1
1
vote
2
answers
200
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 ...
- 583
0
votes
1
answer
76
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 ...
- 101
2
votes
2
answers
3k
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,...
- 1,189
0
votes
0
answers
137
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 ...
0
votes
1
answer
195
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 ...
- 112
0
votes
0
answers
360
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 ...
1
vote
2
answers
149
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 ' ...
4
votes
3
answers
2k
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 ...
- 511
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:
===================================
...
- 131
0
votes
2
answers
513
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 ...
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 ...
- 11
1
vote
1
answer
2k
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
169
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
46
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
47
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
6k
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 ...
4
votes
1
answer
5k
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' ...
- 65
0
votes
1
answer
4k
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 \
&&...
- 163
0
votes
1
answer
4k
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
200
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 ...
- 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 ...
- 357
0
votes
0
answers
123
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
138
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 ...
- 173
0
votes
0
answers
273
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 ...
- 1,750
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 ...
- 357
0
votes
1
answer
99
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
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 ...
- 21
1
vote
0
answers
356
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
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:\...
- 1
1
vote
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 ...
- 113
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 ...
[...
- 723
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 ...
- 13.6k
2
votes
1
answer
383
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 ...
- 133