Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

One or more connections to a database or database server. For questions about *establishing* a connection, use the **connectivity** tag instead.

0
votes
0answers
4 views

adding a connection to pgadmin 3 or 4

can u guide me on correct path... or what I'm doing wrong. I have access to postgres db server with root access. These are my steps to connecting to PostgreSQL server: ssh fina@server.ip.address ...
1
vote
2answers
26 views

MySQL: No. of Connections

I have a medium sized database (7 GB) with around 200 concurrent users. I am getting some database lag issues, suddenly my node-mysql client freezes during selects and inserts. As a process of ...
0
votes
0answers
6 views

Asp.Net Application crashes find 0 rows get from database

My asp.net application crashes sometimes in live server while we are using it. All users are facing [Exceptions]yellow error screen.And Throws dozens of exception in exception log. On Tracing ...
2
votes
1answer
48 views

What connection do internal sessions belong to in MS SQL Server?

By querying select * from sys.dm_exec_connections I do not see corresponding connections for internal sessions, about the existance of which I know from sys.dm_exec_sessions DMV. My questions is ...
0
votes
1answer
25 views

database connection and sessions in an example of social media

I am referring to MS SQL connection and sessions. I know that each application should make a connection in order to access the database, and each connection can have multiple sessions. In case of a ...
2
votes
1answer
168 views

Logon failed for login due to trigger execution

I have been trying to login using one of my sql server logins but I am getting the error message below: General Error Message Copy Message Text TITLE: Connect to Server -----------------------------...
0
votes
0answers
25 views

Desktop application loses the DB connection intermittently

I am currently having a strange issue on SQL server. The desktop application that uses the DB is having intermittent connection failures, then the users have to connect to the DB again and it is ...
2
votes
2answers
41 views

Cannot connect to <instance>. A severe error occurred on the current command

Recently, and on more than one occasion now, we have attempted to connect from one of our SQL Server instances to another using SSMS only to be greeted with the following error: A severe error ...
0
votes
1answer
22 views

Percona pt-table-sync Can't determine Master

We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica Connection ...
1
vote
1answer
20 views

DBForge can't connect with MySQL server, server is running

I recently installed the latest version of MySQL Server. I initialized it with --initialize-insecure so I have a "root" user with no password set. The server is running, with the command mysqld --...
2
votes
0answers
103 views

Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server

OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 19 Cannot ...
2
votes
1answer
79 views

Stored Procedure Execute as Owner Close Database Connections Not Working

I created a stored procedure to allow users to Close All Db connections in the QA environment. I am SA and created the procedure. When I modify the SP , run it Without 'Execute as Owner', I get ...
0
votes
0answers
19 views

How to connect to mdb fie

I have a exe file that read and write from local Db file. I check this file with Detect It Easy and it tell me that is mdb file. I can open this file with Microsoft Access, and watch all the tables ...
1
vote
1answer
43 views

Mysql 5.7 cannot start again

For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04. I installed MySQL 5.7, it worked great for a couple of days ...
1
vote
1answer
17 views

Permission errors on insert after schema drop/create (Pg 9.0.23)

We have a web application that allows users to modify data through an API. In order to allow people to run tests, we provide a sandbox area called 'daily'. This sandbox gets refreshed every day from ...
0
votes
2answers
35 views

Unable to connect from remote computer, while local connection works

I have a Windows 2008 R2 64-bit server with SQL server 2008 R2 installed on it. I manage to log to SQL server with SSMS with the sa SQL account and with a test SQL account. But when I try to ...
0
votes
1answer
48 views

Having multiple ResultSets in parallel on same connection.. Will it cause any problem? [Mysql/Postgres] [closed]

I have tried out the following in my local machine using jdbc/mysql: step 1: conn = getNewConnection step 2: stmt1 = "new statement" using connection 'conn' step 3: stmt2 = "new statement" using ...
0
votes
1answer
145 views

“undefined function pg_pconnect()” when connecting to Postgres from CodeIgniter

I just installed Postgresql and pgadmin in my Ubuntu system. I can create a database from the pgadmin interface and everything seems ok, but when I try to connect to the database from my CodeIgniter ...
1
vote
1answer
154 views

in what situations the dynamic port number in sql server is used?

I have the following script to find out what is the Static and dynamic port numbers: --=============================== -- sys.dm_exec_connections --=============================== SELECT [user]=...
1
vote
2answers
33 views

Connections increasing by 10+ a second with no requests

I'm getting no answers from my host, but I suspect their DB servers are compromised. I was getting some ridiculous page loads for requests to a standard Wordpress installation - upwards of 30 seconds,...
0
votes
1answer
475 views

What reason could cause AWS RDS connections to

It's my first time using RDS on AWS, I use a t2.medium instance running MySQL Aurora with default configs. The CPU usage and DB connections is quite normal until "something" happen, which cause the DB ...
1
vote
1answer
268 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
0
votes
1answer
29 views

Check connection details to SQL Server 2000/2005

I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014. I don't have direct access to the databases and I want to know all applications connecting to it and connection ...
0
votes
2answers
388 views

Cannot connect to mongos

Following the MongoDB Sharding Documentation, I start a mongos using a configuration file with the specifics of my config server. It seems rather straightforward, yet I am running into an issue. I ...
0
votes
0answers
29 views

How do I set up an Active Directory group to use with DSN-less linked tables from MS Access to SQL Server

I have set up a group in Active Directory. I have added all my users to that group. I have set up a login for the group with default database as mydb. The login is a member of the public server ...
1
vote
1answer
210 views

Azure SQL Databases: High number of SA connections with “BRKR TASK” and “TASK MANAGER” commands

Found out that all our Azure SQL Databases (pricing tiers S1-S2) have high number of connections/sessions from SA SA - BRKR TASK - around 60 sessions SA - TASK MANAGER - around 20 sessions Here are ...
0
votes
1answer
50 views

What if a connection closes in the middle of a commit?

I have a few large CSV files to upload to an instance of SQL Server.(Nope, can't use SSMS) I'm using JDBC to read the CSVs line by line and insert the lines in a table in batches. Supposing my code is ...
0
votes
0answers
26 views

Repeated login failures from SSMS to different databases

I have a SQL Server 2016 instance. One user has a login with a user mapped to a single database on this instance. Whenever the user is connected to the instance, a login failure is generated every 5 ...
0
votes
2answers
172 views

How to connect from local computer (mac) to remote Oracle DB and execute script and save results to CSV?

I can connect to remote Oracle DB using this signature: sqlplus 'user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))' Now want to ...
0
votes
1answer
912 views

Python Postgres psycopg2 ThreadedConnectionPool exhausted

I have looked into several 'too many clients' related topic here but still can't solve my problem, so I have to ask this again, for me specific case. Basically, I set up my local Postgres server and ...
1
vote
0answers
87 views

Postgres vacuum drops connections

I receive randomly errors for database connections, like: socket closed. I observed postgres logs and found suspicious line: database system was interrupted. Can that happen that postgres drops the ...
1
vote
0answers
168 views

Keeping MySql connections alive

I'm running a Windows service, which connects to a MySql database via Entity Framework. Every 10 seconds it issues a query to the database to see if any new records have been added. If it finds any, ...
1
vote
1answer
494 views

Reasonable values for thread_cache_size in relation with Connections [closed]

I want to know reasonable values for thread_cache_size in relation with the connections that you have. Which is the good proportion? And which proportions do you handle in relation with your clients ...
0
votes
3answers
111 views

How to limit the number of sessions for a specific login [closed]

How can we let just one program to connect to the database, in case many programs have the connection string. (limit the number of sessions for a specific login)
1
vote
1answer
114 views

SQL Server Error “Database 'mssqlsystemresource' does not exist.”

On Linux, whenever I run use mssqlsystemresource to get access to Resource Database, I get an error. How do I resolve this. 1> use mssqlsystemresource 2> go Msg 911, Level 16, State 1, Server ...
1
vote
3answers
346 views

Error Message Saying “Invalid Object Name” [closed]

I have been following a SQL course for the past few weeks and I never have had this problem: my database is connected but I get the error message saying "Invalid Object Name". Please see picture.
0
votes
1answer
1k views

Unable to connect to pluggable database in Oracle 12c

I have oracle database Oracle Database 12c Enterprise Edition 12.2.0.1.0, and I created a pluggable database named DEVDB to use it in web application development, I created it using the Database ...
0
votes
1answer
325 views

Connect Oracle Database 12c via SQL Developer when it is in restricted mode

I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked. Kindly help ! Added (UR=A) in tnsname....
0
votes
1answer
21 views

Can't see connexion to Postgresql using php

I have created a php form to connect to a remote postgresql database. It seems that I can log in successfully because my message "connexion succeeded" appears. But I can't see the corresponding line ...
2
votes
2answers
305 views

Blank Login In sp_who2 Result

There are some rows in the result of sp_who2 which their Login column value is null (see image below) while the login_name column of sys.dm_exec_sessions is not blank and this sometimes happens ...
4
votes
1answer
2k views

SQL Server SSL Encryption - SelfSign Cert working - why?

I realize this is strange behaviour and I wonder if it is supposed to be working that way when using SQL Server generated self-signed certificate. Client (Management Studio) with "encrypt connection" ...
4
votes
2answers
1k views

Always On Availability Groups with Encrypted Connections

We have a two-node SQL Server 2016 AOAG, TestA, TestB and listener TestL. We want to begin using encrypted connections between the app server/client and the db server. I have found the section below ...
3
votes
1answer
2k views

SQL server temp table using # - is it only accessible by the containing query for multiple connections with the same login?

Say we have 2 completely different queries, that reference a temp table with the same name: query one ....operates on: #tempTableName query two ....operates on: #tempTableName I've ...
1
vote
0answers
182 views

“must be superuser or have the same role to terminate other server processes” with PostgreSQL

Postgres 9.4.12 locally and 9.4.7 on AWS RDS. There are two database users: app and untrusted_dev (the latter to mirror AWS RDS: NOSUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION). app is ...
2
votes
1answer
230 views

Application unable to connect after doing a failover ,Mirroring

After doing a failover to mirror database, the application is throwing below error Login failed for user 'NT Authority\anonymous logon'. reason: could not find a login matching the name provided In ...
1
vote
1answer
53 views

Enabling both local and remote connections to a mysql server on linux (ubuntu)

Is there any way to enable both remote connections and connections via "localhost" to a mysql server. I tried adding both bind-address = 127.0.0.1 and bind-address = externalIP but it just used ...
3
votes
1answer
835 views

Find source of spids that show no hostname

I have a busy SQL 2012 server where connections to one particular database (using the same SQL login) don't show a "hostname", and I need to find out which box (of several) these connections are ...
2
votes
0answers
42 views

Unexplained connections from one SQL server to another

I just installed 2 SQL Server 2016 Enterprise and configured a High Availabilty Group. As a test object for the HA-Group I used a database I restored from another server. It's a database called "...
0
votes
1answer
481 views

Elapsed time in SSMS is consistently higher than SQL Server Execution Time - connection issue?

I have a fresh install of SQL Server 2012 Developer Edition on a pretty snappy laptop. I'm using it as a backend for an ASP.NET webapp. I noticed query timings that were consistently higher than I'd ...
2
votes
1answer
359 views

What is the sense to use server_lifetime with PgBouncer?

I've found server_lifetime option in PgBouncer config, and I'm trying to undestand if it is really needed in our case. https://pgbouncer.github.io/config.html The pooler will try to close server ...