The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
33 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
0answers
22 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 ...
0
votes
1answer
99 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 its showing "Argument "ORARACOCCUAT1.xxxxxxx.COM" for option "connection" is not valid. The command line parameters are ...
0
votes
1answer
28 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
17 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
63 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 ...
0
votes
1answer
112 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
59 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 ...
0
votes
1answer
82 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
61 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
49 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
62 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
39 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
63 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 ...
0
votes
2answers
4k 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
27 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 ...
0
votes
0answers
46 views

SQLSTATE:HY000, SQLCODE: -385

I am getting the following error when I try to deploy my tabular model to a local instance localhost\tabular The model processes on my local PC with no errors but when I try to deploy it fails with ...
0
votes
4answers
5k views

Remote MySQL connection fails (10060) - “Can't connect to MySQL server on domainname.com(10060)”

I have developed one application in vb6, and i am using online MySQL database server for storing my application's data. So when i am try to connect with my database server,when first time i connect to ...
0
votes
1answer
172 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
103 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 ...
0
votes
1answer
85 views

AD group cannot connect to SQL from excel

We have a data warehouse and users are trying to browse the database directly from excel. We put those users in an AD group and give them read only permission to a couple of databases. The problem is ...
0
votes
1answer
123 views

Large long-running reporting queries are causing very slow new mysql connections

Usually, mysql's connecton time is in the 0.001 second range. However, when I run a large reporting query (that spans multiple tables with aggregates), I get tons of warnings saying that new mysql ...
0
votes
1answer
475 views

Connect to PostgreSQL via a ssh tunnel using Cygwin

I would like to connect to a Postgres server installed on a remote server using an ssh tunnel. I have Windows so I use cygwin for SSH. I do the following on cygwin: # Create the tunnel ssh -f ...
3
votes
1answer
98 views

How can I create notification on user's connecting to database?

I have users that have access to several databases. I used to have an alert and notification sent to me when a specific user connects to a specific database, but I accidentally clobbered it. Now I ...
0
votes
1answer
83 views

Forget login from connection drop down menu [duplicate]

Recently I logged myself as a different user (testUser) but now that user seems to be persisted in the drop-down menu of connection dialogue box and I couldn't find a way of getting rid of it. Even ...
4
votes
2answers
454 views

Is a Postgres long-running query aborted if the connection is lost/broken?

If I open a connection to Postgres and issue a long-running query, and then break the connection (e.g., kill the client process that opened the connection), will the long-running query continue to ...
0
votes
0answers
119 views

Mysql connections not closing

I have a web application running on Tomcat7 that connects to MySQL 5.5. I have two servers running the identical code: Ubuntu Red Hat The Ubuntu one runs fine maintaining a steady 8-16 ...
0
votes
1answer
146 views

Unresponsive database, sleeping processes

my mysql database suddenly became unresponsive: OperationalError: (2003, "Can't connect to MySQL server on '<IP_address>' (110)") After killing the processes: ...
1
vote
1answer
193 views

Proxy authentication for PostgeSQL

The following seems likely to be a fairly common situation, but I haven't seen any solutions. I have a PostgreSQL database containing views that are specific to the $user, in order to restrict data ...
0
votes
0answers
126 views

DSN connection and RODBC on windows 8

I wish to run queries on a PostgreSQL database in R using the RODBC package. Before I had windows 7 and it was working but now trying to make it work on windows 8 I have not yet succeeded to find ...
3
votes
2answers
460 views

0xDBE how to connect over local socket?

I want to connect to mysql over socket. This is what I'm trying to do: and it's not working. This is how it works in mysql workbench:
0
votes
1answer
263 views

Postgresql tries to connect to fe80::1, permission denied

I upgraded a couple of days ago to IPv6 on my local test machine and since then I've been experiencing some issue with connecting to my local PostgreSQL server. I set the host to 'localhost', which ...
0
votes
0answers
18 views

How does database connection actually works? [duplicate]

I am wondering, on a practical level : what is a database connection? What does it represent for PHP/Java/Ruby/etc to have an opened connection for instance? What about the MySQL deamon? Does it ...
2
votes
1answer
4k views

How to limit the connections per host in MongoDB?

I'm running a mongo server which accepts connections from other clients through java driver. The thing I have noticed is after a while some users open too many ports, and this prevents other users to ...
1
vote
1answer
213 views

Setting stack-size ulimit for mongodb to reduce connection overhead

I am using MongDB 2.4.9 and working on performance tunung. With reference to the ulimit settings for mongodb, in my linux environment (ubuntu 12.04) the default setting for ulimit -s is 8192. MongoDB ...
0
votes
1answer
193 views

Does “Connect” statement for every query indicate broken connection pooling?

there's only one client application running queries against a MySQL instance. After enabling MySQL's general query log (configured to log every query) I noticed that every query starts with a ...
1
vote
2answers
397 views

Analysis Service Connection String

I use sql server 2012, and have multi cube. I can connect to my created cube from Excel (Data Tab\Connections) with windows authentication. How can set permission to SQL Server user on my cube. and ...
2
votes
1answer
325 views

High Number of Connections

The below query tells me there is a total of 520 connections to our SQL Server database. Status of all is 'sleeping' except for 4 connections. The login_time goes back to 2 days ago on some ...
1
vote
1answer
131 views

Get the application name

Is it possible -- does a perfmon counter exist -- that would show the name of the end-user application that is connecting to SQL Server?
0
votes
0answers
38 views

Intermittent Connection Speeds SQL Server 2008

We are having issues with a PHP-based application connecting to an SQL Server database on a separate server. It uses a single PHP page to establish the connection using mssql_connect, and this page ...
0
votes
1answer
163 views

How to avoid/prevent Aborted Connections in mysql

We are using MySQL Version 5.1.73. Database is getting huge number of connections around 600 at one time. I observed Aborted Connections are getting increased from Global Status variables. So I ...