Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
0
votes
1answer
1k views

UFT to SQL Server conecction which is located at different domain

I need to connect to a SQL Server through UFT (Unified Functional Testing) but the problem is SQL Server is present at different domain whereas QTP (HP QuickTest Professional) is present in a ...
3
votes
2answers
1k views

Unable to remotely connect to Postgresql 9.5 instance

I am struggling to connect to a remote Postgresql 9.5 instance running on Ubuntu 16.10. The usual: psql: could not connect to server: Connection timed out Is the server running on host "xx....
4
votes
3answers
17k views

The connection is broken and recovery is not possible - sql server error

I am having the following sql server error, while creating tempDB files. Any ideas? The connection is broken and recovery is not possible. The client driver attempted to recover the connection ...
1
vote
0answers
55 views

2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:

We are getting continuously logs in mysql error logs 2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets) we ...
5
votes
1answer
4k views

Can not connect to SQL Server from Ubuntu sqlcmd client

I'm trying to connect to a SQL Server Express server from a Linux Ubuntu 16.04 computer. I Installed all SQL commad line utilities for the linux machine and follow instructions from Microsoft SQL ...
1
vote
2answers
10k views

Connection problem different errors .net application

We have a SQL Server with some relational databases. We have another webserver with applications which communicate with the databases. We have an issue with one of our customers. We get some errors ...
3
votes
1answer
471 views

Cloned production SQL Server now Windows Authentication doesn't work

I needed to create a test environment for one of our applications that uses SQL Server as its data store. Our sysadmin cloned the existing production server to create the test server. I can connect ...
3
votes
1answer
5k views

0x80131904 - An existing connection was forcibly closed by the remote host

Using the Microsoft.Net v4.0 SqlClient connectivity built-in to Microsoft.Net via the System.Data.SqlClient assembly, a particular machine cannot connect to a particular set of servers. When ...
0
votes
1answer
444 views

I am trying to connect My R studio to SQL Database on the Remote Desktop

The SQL Server on the remote desktop is configured to have neither login nor password, it is configured to use Windows Authentication. Code I am using the following code to connect: library(DBI) ...
1
vote
3answers
21k views

Browse for Servers does not display local instance

I just installed SQL Server and SQL Server Management Studio but it doesn't show anything in servers list and I don't know how to connect to it. This shows that I have installed SQL Server: But ...
1
vote
1answer
77 views

Lost SQL credentials and unable to connect to SQL via SQLCMD

I have a machine running SQL 2014 but have neither the windows authentication or sa authentication details due to mismanagement of a previous support team. Having tried logging in to SQL Management ...
3
votes
0answers
777 views

Connection timeout via AlwaysOn Listener IP on local computer

I have AlwaysOn availability group and it has one Listener IP. I can connect this instance using Listener name but, cannot connect using Listener IP from my local computer. It returns following error ...
1
vote
2answers
723 views

What determines the maximum number of concurrent connection to SQL Server 2016 Express

After some googling, there seems to not have a straight forward answer to the question. MSDN Forum mentions it depends on CPU, Memory usage, database size etc. Could someone help explain or perhaps ...
30
votes
6answers
34k views

SQL Server compatibility with New TLS Standards

The major browsers are moving beyond SSL3.0 and TLS1.0 . The PCI Security Council has declared an end-of-life date for these protocols to be considered sufficiently strong encryption. We need to move ...
0
votes
1answer
9 views

SQl connection to XAMP

i am trying to connect my database to XAMP . I got this error Warning: Use of undefined constant ID - assumed 'ID' (this will throw an Error in a future version of PHP) in C:\xampp\htdocs\Thairis\...
4
votes
2answers
838 views

SQL Server trusted connection additional security

Using Windows authentication, is there a way to prohibit users from connecting via ODBC to the database?
1
vote
1answer
2k views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
0
votes
2answers
84 views

Getting Error 10054 after renaming the server

When I open SQL Server I have error 10054. Recently I changed the server name and I probably have this problem since. How can I solve it?
0
votes
1answer
59 views

The service broker is administratively disabled

I have just restored some databases what use service broker from LIVE to staging. it is not working and when I put a profile trace to run it only shows messages related to database id 1 and 4, ...
9
votes
3answers
26k views

Tracking Down Application Timeout Errors in SQL Server

SQL Server 2008 SP3 How do I track down these timeout errors ? The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a ...
0
votes
2answers
142 views

What happens if you lose the connection during a huge insert?

What happens when you lose your connection with the DB during a huge insert. Will part of the data be inserted? Will nothing be inserted? What is the reason for this? The example statement I am ...
0
votes
2answers
74 views

pre login initialization =29237; handshake=26244

Connecting to one of my servers (no mirror or availability group running), from a local machine and I get this error message below related to handshake when the firewall is up. when the firewall is ...
2
votes
2answers
1k views

Oracle connection suddenly refused on windows 8

I am having all kinds of connection issues with sql developer all of a sudden. It was working till yesterday and stopped working on windows 8 machine. I am still able to connect via command prompt. ...
2
votes
2answers
177 views

One database listening on two database names

I know this is a sort of odd request. I myself have never had to even think about a scenario like this until today. I'll go straight to the point to make the question easy to read. I suspect the right ...
1
vote
1answer
205 views

Why changing the order of network protocols does not make any sense?

All I want to do is to connect to SQL Server though Named Pipes without using an explicit way like NP:ServerName because mentioned approach works. I want to connect through Named Pipes using just ...
0
votes
1answer
87 views

Keyword not supported: 'statslog_on'

I am trying to connect to a SQL 2017 instance via SSMS 18.2 with the 'Additional Connection Parameters' StatsLog_On=Yes;StatsLogFile=C:\Temp\TestODBC.txt The documentation at Using Connection String ...
7
votes
1answer
3k views

Does SSMS use ODBC?

I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances. I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes ...
2
votes
5answers
28k views

MySql-Workbench: Can't connect to MySQL server on '127.0.0.1' (111)

The hard data first: Local machine: Xubuntu 17.10, with MySql-Workbench 6.3 Remote Machine: Ubuntu 16.04, with MySql-Client 5.7 and MySql-Server 5.7 The connection method is: Standard TCP/IP over ...
3
votes
1answer
468 views

How to set IP segment and connection string with IPv6?

For this PostgreSQL configuration example: https://repmgr.org/docs/4.4/quickstart-authentication.html local replication repmgr trust host replication ...
2
votes
3answers
565 views

“Network-related or instance-specific error” while attempting connect to a SQL Server on remote computer on home network

I have two laptops (both running Windows 10, 64-bit) connected to my home network using wifi. Here are details about each laptop (please ask if you need more info): Laptop #1 2017 Microsoft SQL ...
1
vote
2answers
23k views

Unable to import mysql.connector in a Python venv session

I've used venv to create a virtual environment for Python 3.5.2. I have installed the mysql.connector. The connector works fine as long as I am not in an activated venv environment. from mysql....
5
votes
1answer
2k views

SQL Server on Ubuntu - An existing connection was forcibly closed by the remote host after reboot

I have been running SQL Server on Ubuntu for a while and everything has been working fine but I rebooted the server and now all connections to SQL Server fail with the error: A connection was ...
1
vote
0answers
349 views

database mirror - A connection attempt failed because the connected party did not properly respond after a period of time

I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs: --Execute it on Primary/Secondary server EXEC ...
2
votes
1answer
4k views

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h 10.0....
0
votes
1answer
56 views

Couldn't connect to databasee

I have a dedicated webserver and a dedicated database server. Often, I get errors connecting to the database server couldn't connect to database Here is my current /etc/my.cnf configuration file [...
0
votes
2answers
447 views

MySQL connection timeouts

Apparently, a former DB administrator configured our main DB server (located in Germany) so that it only would be accessable from certain IPs. Now we just added a new host (which needs to access that ...
0
votes
1answer
96 views

MySQL Connection Error for TDV

I am trying to connect to a MySQL database using Tibco Data Virtualization Studio (TDV). I was able to connect to the database using MySQLWorkbench. I checked my.cnf and skip-networking is not ...
1
vote
0answers
40 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
3
votes
2answers
83k views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
1
vote
1answer
135 views

How To Access My PostgreSQL Server From Another PC Securely?

I want to be able to connect from any PC anywhere to my Database. Host OS: Windows 10 PostgreSQL: 12.0 Currently all Tutorials say the same: (Thats what i also did) Change listen_addresses to ...
1
vote
1answer
413 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
5
votes
2answers
14k views

SQL Server Error while creating User

I tried creating a user with all privileges but I am getting this error: Microsoft SQL Server Management Studio Create failed for User 'Hru'. (Microsoft.SqlServer.Smo) Additional ...
5
votes
1answer
262 views

how to stop using sql server login credentials in a linked server?

I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1 we are on different but trusted domains. The connection from server_italia to ORDB1 is made ...
1
vote
0answers
385 views

Aborted connections (Erros reading communication packets)

I set up a new Database Server over a SQL Dump with innoDB MYSQL 5.7 from MYSQL 5.6. The Server running external with many sleeping SMTP connections over 1 Mio a day. I made the server open for ...
24
votes
4answers
40k views

SQL Server Management studio slow connection or timeout when using Windows Authentication

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication. This happens when ...
1
vote
1answer
445 views

Connection to PostgreSQL disconnects every hour regardless of activity

I'm monitoring my PostgreSQL clients using a periodic netstat -an | grep 5432 | grep EST to check the ESTABLISHED status of the connection every 5 minutes. I have noticed that all of the connections ...
2
votes
1answer
745 views

Listener protocol error - Oracle [closed]

Okay first things first, this is probably a common issue which gets resolved going through all those questions and googling it but still I face this issue: LSNRCTL> service Connecting to (ADDRESS=(...
1
vote
1answer
3k views

SQL Server Replication Snapshot Agent login fails

I have setup TRANSACTIONAL REPLICATION from ServerA to ServerB ServerA = Primary Server = SQL Server 2008 R2 Enterprise ServerB = Secondary Server = SQL Server 2008 R2 Standard Edition. I ...
0
votes
2answers
4k views

Login failed for user NT AUTHORITY\IUSR

I have some developer colleagues in my office that are having a problem similar to this one: db connection uses an anonymous logon instead of the domain user the connection string (he is working on ...
2
votes
2answers
733 views

SQL Server Management Studio DAC connection error

I'm trying to connect to SQL Server 2012 via DAC using Management Studio. I type admin: before my server name, yet I keep getting the same error: A network-related or instance-specific error ...

1
2
3 4 5
7