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

learn more… | top users | synonyms

0
votes
1answer
24 views

Pooler (pgbouncer) + MasterDB + Slaves

During a spike, my connections go from 30 to over 140, as you can see below: I'm willing to set-up a pooler like pgbouncer, but have some questions as my scenario is not that easy: 1 Load ...
2
votes
3answers
80 views

Injecting connection context information using a persistent table

I am working on an application that has several legacy modules that rely heavily on stored procedure (no ORM, so all fetches and data persistence is done through stored procedures). Security for ...
0
votes
0answers
39 views

MySQL Too Many Connections (Max Connections Limit Not Reached)

Running a PHP 5.6 application that connects via MySQLi to a MySQL database (5.5) that intermittently errors with the "Too many connections error" however this seems to be a red herring to another ...
0
votes
1answer
31 views

Lots of isMaster queries running

I see a lot of these kind of queries running on my primary server where all the replica set members keep checking if the Primary is Primary by running isMaster: query: { ismaster: true } ntoreturn: ...
0
votes
0answers
15 views

Can connect to the local server default instance with the servername but not via other means

I have noticed that I cannot connect to the default (and the only) instance of a production server (SQL Server 2008 R2) by specifying [single dot]., (local) or 127.0.0.1 but can by specifying the name ...
0
votes
0answers
10 views

Logging connected threads when “to many connections” occured

Can I get information (for example from log file) about threads connected when "too many connections" error occured? Is that possible (MySQL or others)? For example: Application is trying to ...
5
votes
3answers
549 views

Find all IP's or users who access a specific SQL Server

Let's say I found a SQL Server and I have no idea which applications connect to it. Maybe I find one application but I am not sure if it is the only one using it. Is there a nice way of finding all ...
1
vote
0answers
42 views

Why does the 9th Sql Connection in a row fail with a transaction manager error? [closed]

I am debugging an asp.net application on local machine that is connecting to a remote SQL Server database and run into an unhandled execption saying: System.Runtime.InteropServices.COMException: ...
0
votes
0answers
23 views

Lua and Torch, how to implement a connection pooling in LuaSql?

I've been working in a project that uses Torch and Lua, and connects to a PostgreSQL database through LuaSql. My script often reaches the maximum number of connections to the database, and (because ...
1
vote
0answers
41 views

Exactly what are MySQL connections? [closed]

There are tons of questions on how to deal with errors around reaching the maximum number of connections in MySQL. I often program in PHP so answers generally range from changing the max_connections ...
1
vote
1answer
91 views

Is there a way to throttle MySQL requests to mitigate DoS traffic?

I've a server with ~200 wordpress websites hosted. When Google Favicon bot pays us a visit it searches all the sites indexed on our IP, that means it's requesting ~200 favicons. Most of the sites ...
-2
votes
1answer
66 views

Connect an desktop application to my SQL Server using internet

I want to connect a desktop app to a SQL Server using internet, not local. The app will run on every network in the world with internet and the data will retrieve and send from my PC using SQL ...
16
votes
2answers
777 views

Max number of user connections

In SQL Server 2012 Standard edition, I know that the max number of user connections is 32,767. What should I do as a DBA if I am heading towards this number? Currently there are 30,000 user ...
2
votes
1answer
96 views

Significance of “.WORLD” on end of Oracle connection

What is the significance of having ".WORLD" on the end of an Oracle connection name? I've found things to still connect without that suffix. I've also noticed that both the client tnsnames.ora file ...
-3
votes
1answer
155 views

Unable to connect to SQL server 2008 R2 via computer name [closed]

I wrote a program, on my computer it works correctly because SQL Server us running on my computer, but another computer in the network can't use the database. Here is the definition of the connection ...
0
votes
1answer
20 views

Problems to connect to an Oracle Database with SQLPLUS and URL-Variable, can somebody explain what I have to do?

I would like to connect to a ORACLE database via SQLplus. If I do it this way: sqlplus "user/pw@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = ...
3
votes
1answer
54 views

Are database connections from an application expensive from a performance point of view?

A colleague tells me that connections to a database are expensive and could harm performance of the application. They ask me to create a procedure that calls say another 8 procedures, that way they ...
-1
votes
2answers
55 views

MySQL Server Disappeared

I haven't used my MySQL local server in over a year. Today I tried to get in to it, and the server seems to have just vanished. I've been searching a troubleshooting all day and have gotten nowhere. ...
1
vote
1answer
43 views

Not able to connect to local MySql database “only” when connected to VPN on VM [closed]

Setup: MySql installed on my Mac using Xammp VM installed using VMware Fusion running win XP. I am able to connect to the mysql database through my VM normally. As soon as I connect to a VPN it ...
0
votes
1answer
150 views

psql: could not connect to server

when I'm executing U postgres -d "phoenix" -a -f "/northstar/phoenix/runtime/Daily-script/query.sql" this command i got the following errore psql: could not connect to server: No such file or ...
1
vote
0answers
137 views

Suddenly unable to connect to PostgreSQL

I have a simple backend running on a server back at my house while I'm away at college. I had it just sitting there, doing nothing, with daily endpoint tests for about a month, when suddenly yesterday ...
4
votes
1answer
64 views

Any potential issues/ DoS risks with frequent connections/ queries to a SQL Server db?

A database team suspects there may be an issue with a third-party ETL application opening, and closing, connections to a SQL server database repeatedly. In terms of exact numbers --- it opens about ...
2
votes
2answers
180 views

How can I check if connection to Sql Server is encrypted?

In Sql Server I can Force Encrytion in protocols settings. If I leave that set to No any client can still require encryption. Can I somehow see what connections to the database are using encryption?
1
vote
1answer
40 views

Remote access from domain and other pages on that domain

I know that you can access a database from a domain name with a user like this user@example.com but will this user also be able to access the database if they are trying to connect via another page on ...
1
vote
1answer
2k views

Cannot connect to MySQL sever with MySQL Workbench

I am using MySQL 5.6.26 Community Server on a Mac OSX 10.10.4. The server is running, according to the preference pane utility. Also I can connect to the server using the command line tool with the ...
1
vote
1answer
90 views

SQL Server remote connection to 2nd instance impossible

After installation of another SQL Server 2014 instance to a server where a default instance of SQL Server 2008 R2 is present, I cannot remote connect remote to the new named instance. The default ...
2
votes
1answer
58 views

MySQL connection process slow for non-root user

I'm using Percona server 5.6 on Linux. When I connect to MySQL from the command line as the root user, it connects immediately. I have also created a new user in the database, but when I try to ...
0
votes
1answer
201 views

Exception when trying to connect to remove MySQL from Intellij IDEA

I can't connect from Jetbrains IDA to my MySQL at AWS. I am getting exception: Connection to MySQL - aws failed java.sql.SQLException: Communications link failure The last packet sent successfully ...
1
vote
1answer
3k views

Oracle intermittently throws “ORA-12516, TNS:listener could not find available handler with matching protocol stack”

While testing the Oracle XE connection establishing mechanism I bumped into the following issue. Although connections are closed on each iteration, after 50-100 connections Oracle starts throwing ...
0
votes
1answer
1k views

SQL Server connection string

I have moved a site from a Window Server 2003 server to a Window Server 2008 server (64 bit). The site connects to a SQL Server 2005 database. I imported the database, and I am running it under SQL ...
2
votes
1answer
81 views

What does Oracle use for handling a client connection (process or thread)?

SQL Server 2016 and MySQL 5.7 use thread-based connection handling. PostgreSQL 9.5 uses one operating system process for each individual connection. According to Oracle 12c documentation it's not ...
1
vote
2answers
239 views

Access to database denied :ELEPHANTSQL on Bluemix - “No pg_hba.conf entry for host localhost, user ADMIN, database SYSTEM”

While trying to connect to my ElephantSQL database on Bluemix using pgadmin, it throws the following error. Access to database denied The server doesn't grant access to the database: the server ...
1
vote
1answer
325 views

Multi-thread Informatica connections to use different processors on target database server

See this question for reference. Can data streams from Informatica to SQL Server be multi-threaded? I've got most of my problem figured out. I've split up the one large table into four smaller ...
1
vote
1answer
2k views

SSIS Job “Argument ”ORARA********.xxxxxxx.COM“ for option ”connection“ is not valid. The command line parameters are invalid. The step failed. ” error

My SSIS package is running fine in BIDS but when I tried to schedule the job it's showing: Argument "ORARACOCCUAT1.xxxxxxx.COM" for option "connection" is not valid. The command line parameters ...
0
votes
1answer
127 views

Redirect Connections to a SQL Instance

I have a LAN in which clients connect to the SQL installed on a Server with the IP address of 192.168.1.10 (SERVER_A) . I have another SQL instance installed on another server with the IP address of ...
0
votes
1answer
32 views

Connection to a MySQL server fails after server restart

Until this morning I could connect via Sequel Pro to one of our networked machines that has the MySQL server on it. Today, however, it's another story: when I am trying to connect, it times out. Even ...
1
vote
1answer
222 views

What connection string to use to connect to network server?

I have a database on my computer running on SQL Server Express 2014, and I'd like other computers connected to my network to be able to connect to it using a C# program I wrote. I've done the ...
2
votes
1answer
2k views

Azure SQL Database “Login failed for user” in application, but works fine in SSMS

I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me. I created a database called Classifier. I added my ...
0
votes
0answers
223 views

sys.sp_reset_connection. Why theres a lot of them ?

Theres a lot of questions here on DBA EXCHANGE. But none of them can help me. I have 2 problems: 1) Using sp_whoisactive, I found lots of sys.sp_reset_connection;1( I know they are ...
1
vote
2answers
2k views

JDBC local MSSQL Server connection string

I have installed open source database management tool "dbeaver" and want to use it instead of Sql Server Management Studio. But there is a problem. I searched from the internet but somehow I could not ...
0
votes
2answers
209 views

How to block external connections for an Oracle database?

I have an oracle database (11g-r2) on my (windows) computer for development, and I am trying to forbid any outside connections. Is there a way to do this?
1
vote
0answers
247 views

Excel and Oracle SQL Connection

I am connecting to an Oracle DB and return data with Excel 2010. I have setup the connection in my workbook and my connection string looks as follows, ...
0
votes
1answer
246 views

Mysql - Examine last query run by thread in sleep state

I am seeing some threads in the "sleep" state for longer than normal. Normal maybe being 1-3 seconds with the abnormal being up to 60 seconds or longer. It makes sense that this is an application ...
0
votes
0answers
170 views

How to identify a client application whose host_process_id points to sqlserver.exe

I am in the process of trying to identify a client application which uses one of the SQL Servers I support (2008 R2). Periodic queries against sys.dm_exec_sessions regularly return sessions whose ...
0
votes
0answers
158 views

Can't connect to other instance of SQL Server 2012

I'm working through a Microsoft exam study book. I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC. The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
2
votes
3answers
48k views

How to solve “Can't connect to local MySQL server through socket” error?

I kept getting this following error every time I tried to restart MySql. It was working fine before I changed the default data directory. ERROR 2002 (HY000): Can't connect to local MySQL server ...
0
votes
1answer
38 views

MySQL max_connctions+1

I experienced an incident that my connections are full. Even I as an administrator I cannot log to MySQL due to "too many connections.". Does anybody knows how to setup this max_connections+1? I use ...
1
vote
1answer
435 views

Connect to remote EC2 Postgresql database

I want to setup a connection between a webserver and a PostgreSQL 9.3 server. Both are hosted on Amazon EC2 servers and are part of the same security group. I can't get the connection working. The ...
1
vote
2answers
56 views

Is there an easy way to update connection strings to a database moved to a different instance

I have created a new instance of SQL Server 2008 r2 and exported my database to the new instance. Then I realized that the connection string for all of my datasets still point to the original ...
1
vote
0answers
187 views

SSMS login fail to Linked Server

i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication every time when ...