Questions tagged [connectivity]
Establishing a connection to a database or database server.
412 questions
0
votes
1
answer
24
views
RDS - connect to HA Secondary without joining domain
I am attempting to connect to the secondary replica in an HA RDS cluster. Usually I do this by connecting to hostname.vpc.local with the master user SQL Auth credential. Today I restored an HA cluster ...
- 5,931
-5
votes
1
answer
237
views
The query times out when executed through the application
I have a query that, when executed in SQL Server Management Studio takes only 2 seconds to run, but when I execute it through the application, it takes 1 minute and times out. I increased the timeout ...
- 41
0
votes
2
answers
60
views
what is the role of SSL in postgresql connectivity?
While installing postgresql
downloaded from here:
I get a connection problem that says:
server does not support SSL, but SSL was required
How can I make my server (in this case my laptop) support SSL?...
- 17.3k
1
vote
1
answer
136
views
DBA but cannot connect to SQL Instance - "User does not have permission to perform this action (Error 15427)" [closed]
I am a DBA with local sysadmin rights, and sysadmin rights on the SQL instance. Up until recently, i have been able to connect to a SQL Instance without issue.
All i am trying to do is connect to a ...
- 55
2
votes
1
answer
107
views
How to count the number of connections to a postgres database?
The configuration file postgresql.conf contains a setting for max_connections.
I have a number of related questions...
In the context of this value, what exactly constitutes a 'connection'?
What's ...
- 1,313
0
votes
1
answer
121
views
Mysql "ERROR 1045 (28000): Access denied" only when host is specified
I'm scratching my head with this issue.
I have an Azure flexible for MySQL server with MySQL 5.7.
I've created and give grants for a new user with the "%" wildcard, following the syntax (don'...
- 668
0
votes
3
answers
255
views
Force Strict Encryption from a C++ Application [closed]
I am using SQL Server 2022 Standard Edition. It has an additional option of setting Force Strict Encryption, which I have set on the server side.
Using SSMS on a client machine, I am able to connect ...
- 69
1
vote
1
answer
562
views
Error when Connecting using SSMS
I'm attempting to connect to an Azure database using SSMS v20.2 and Microsoft Entra MFA for authentication. When I click connect, I get the below error message:
Could not load file or assembly 'Azure....
- 113
0
votes
0
answers
34
views
Connection hangs at password
Basic question: I want to connect 2 systems (A and B, on different networks) to a single mysql database. No problem with the 1st one, but the 2nd one hangs at the password:
A $ mariadb -v --protocol=...
- 101
0
votes
0
answers
112
views
Client timeout connection in MySQL
I'm trying to limit the amount of time my MariaDB client will wait when trying to open a connection to the server. All my searches instead find only server-side limitations for timing out stale/...
- 101
1
vote
1
answer
174
views
Azure DB Server-Roles and Microsoft Entra Groups
I am facing an strange issue dealing with Server Roles in my Azure DB environment when using a login derived from AAD Group (Microsoft Entra) for low-privileged admin/deployment activities (such as ...
- 11
4
votes
0
answers
560
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 ...
- 71.1k
0
votes
1
answer
2k
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:...
- 17.3k
0
votes
0
answers
129
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
236
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 ...
- 17.3k