Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-connection]

57 questions
1
vote
1 answer

MySQL Workbench and error Lost connection to MySQL server(system error 10060)

I am begginer in administration of servers. So decided to learn about it a little bit. All actions I perform in the same OS. I setup Microsoft SQL Server 2008 R2 on my virtual mashine(PC name: WIN-EBEI837K420 or IP: 192.168.1.100). SQL Server…
SANRIZE
  • 11
  • 1
  • 3
1
vote
1 answer

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: [Microsoft][SQL Server Native Client 10.0]Login timeout…
przemo_li
  • 61
  • 4
1
vote
1 answer

Connect to MariaDB through SSH fails with error 2013 - Lost connection to MySQL server at 'reading initial communication packet'

I'm trying to connect to a remote MariaDB server through SSH using Navicat Premium from Windows but all the time I can't and get this error: 2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 I have…
ReynierPM
  • 710
  • 5
  • 14
  • 30
1
vote
2 answers

Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth

Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the real world. I need help to get 2012 running. What…
David Eiland
  • 11
  • 1
1
vote
1 answer

Providing database connection via web server

I am creating a database (in PostgreSQL, but this question is hopefully independent of the underlying DBMS) that will be hosted remotely. Most access will be provided through a web-based front end using Apache, but I would like to allow some users…
beldaz
  • 243
  • 2
  • 10
1
vote
1 answer

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question is about tail log backups. Eventually, I need my…
Ranic
  • 111
  • 1
1
vote
1 answer

can't connect to mysql with a host

I have mariadb installed and running. I can connect to it with this: mysql -u dev -p or mysql -h localhost -u dev -p but I can't connect to it using mysql -h 127.0.0.1 -u dev -p It asks me for my pwd, which I enter. but after that it just hangs.…
Anthony
  • 253
  • 1
  • 7
  • 10
1
vote
3 answers

Configuring keepalives with TOAD client communication

I have a scenario where long-idle sessions of TOADSoft client communication with the Oracle server seem to be torn down as they timeout on an intermediate state-full firewall. These sessions could be idle for multiple hours! It is not acceptable to…
nik
  • 7,100
  • 2
  • 25
  • 30
1
vote
1 answer

Performance factors in remote database access

I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server and database server are differnt, the…
Bhushan
  • 151
  • 9
1
vote
2 answers

How to connect to MySql in another Ubuntu machine?

Hi How do i connect to MySql from another Ubuntu machine. I tried this mysql -h 'IP' -P 3306 -u test -ptest I get ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111). then i tried nmap -sS -O -p 3306 'IP' and it says 3306/tcp…
Rakesh
  • 421
  • 2
  • 6
  • 11
1
vote
2 answers

cannot at all find sql instance (while installing an asp.net app on IIS)

So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem now is SQL Server 2008 r2, after figuring out how to…
gideon
  • 1,145
  • 2
  • 13
  • 28
1
vote
0 answers

Can't connect to server until reboot computers

I have a domain with around 90 PC with the domain controller running by Windows Server 2012 R2 and the PCs Windows 7. Every PC has a mapped drive from the server and a database interface that's linked to the database in the server. Everything was…
mohamed al-mahdi
  • 11
  • 2
1
vote
0 answers

Get diagnostics information from failed connect from Grafana to InfluxDB

I've tried to set-up a local Grafana instance in a Docker container and I'm trying to connect to my local InfluxDB that is running on the same machine. I can connect to InfluxDB without any issues, but when I want to setup Grafana to connect to the…
Alexander Pacha
  • 169
  • 2
  • 9
0
votes
1 answer

Adminer or mysql error: no connection could be made because the target machine actively refused it

I have been trying to set up wordpress.org using localbyflywheel, but when I open Adminer I keep getting this error: No connection could be made because the target machine actively refused it, what can I do to solve this error? I am running MySQL on…
user554395
  • 1
  • 1
  • 1
0
votes
0 answers

Why can some users connect to a DB and others can't?

I have a geospatial database that one of my users needs to connect to. Whenever he tries to connect from his workstation he gets an invalid connection/connection refused error. He is not able to connect to it from any other workstation. There are…
Kyle
  • 1
  • 1
1
2
3 4