Skip to main content

Questions tagged [connectivity]

Establishing a connection to a database or database server.

96 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
3 answers
1k views

Named instance throwing error 26 and won't connect

I've installed 3 new named SQL Server 2019 instances on a standalone server. The named install seems to have defaulted to computername\network name. Ex: BHMDB06\sseprod. During the install I had it ...
bwilliamson's user avatar
4 votes
0 answers
4k views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work fine,...
David Aleu's user avatar
4 votes
1 answer
741 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example FROM ...
VS1SQL's user avatar
  • 41
3 votes
1 answer
2k views

SSMS cannot connect to SQL Server 2022 - Internal Error

I'm trying to connect (on the same host) from SSMS 19.0.2 to a newly installed SQL Server 2022 developer edition instance. I am getting a weird internal error: =================================== ...
mikb's user avatar
  • 131
3 votes
0 answers
2k views

PostgreSQL 10.3 pg_dumpall fails: server closed the connection unexpectedly

System: Windows 10 Pro 64bit, Version 10.0.17134 Build 17134. with Postgres 10.3 db server. I backup my postgres db using the following statements: "C:\PostgreSQL\pg10\bin\pg_dumpall.exe" -U ...
Michael's user avatar
  • 295
3 votes
0 answers
3k views

Server Local Connection Provider has stopped listening on local pipe due to a failure

All, I'm looking at a database where every so often, connections to it will fail. The event viewer and SQL Logs have the following error in them: Server local connection provider has stopped ...
The Great Laughter's user avatar
3 votes
0 answers
992 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 ...
Banu Akkus's user avatar
3 votes
0 answers
3k views

PostgreSQL FATAL canceling authentication due to timeout

I have a PostgreSQL 9.4 Database running on my CentOS 7 Server. This database has only ever been available to users on the LAN, however recently I needed to make it available to users outside the LAN ...
TheLovelySausage's user avatar
3 votes
0 answers
311 views

Unable to Update on SQL Server 2008 R2

This is a bit strange so bear with me please. After installing a new SQL Server 2008 R2 on a new server (Windows 2012 Standard) just like the production one, I tried to connect my web aplication (...
Piero van Oordt's user avatar
2 votes
0 answers
34 views

MySQL Client taking more than 14 sec to be connected

IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
Basudev Rout's user avatar
2 votes
1 answer
2k views

SQL Server Profiler - Client unable to establish connection

Spanking brand-new installations of: Visual Studio 2022 Community (VS) SQL Server 2019 Dev (SQL) SQL Server Management Studio v18.10 (SSMS) There are no other Visual Studio or SQL Server instances ...
David Rogers's user avatar
2 votes
0 answers
1k views

connection to remote Analysis Services from SSMS

On my company local SQL Server instance I was able to add a linked server to a remote AS instance (in Management Studio > Server Objects). I was also able to connect using Data Tools, as well with ...
matt's user avatar
  • 21
2 votes
0 answers
54 views

What is the "Optimize Response" connection string attribute used for?

My apologies if this is not the correct forum to be asking this in. I am having trouble finding information regarding the "Optimize Response" connection string attribute. The most promising source of ...
djbzrms's user avatar
  • 21
2 votes
0 answers
1k 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, ...
Bob Tway's user avatar
  • 243
2 votes
0 answers
567 views

Slow SSMS connecting to AWS EC2 instance

I have an AlwaysOn availability group in AWS EC2. 2 nodes, multisubnet, with 1 DC in one subnet, the other DC in a separate (3rd) subnet. All in the same VPC. When anyone connects to either of the ...
Peter's user avatar
  • 1,490
2 votes
0 answers
1k views

SQL Server login failed, but user has permissions

First off, I'm pretty sure I've found every related post on the entire internet, so please read carefully before marking as a duplicate. I have an ASP.NET site, hosted with IIS, using SQL Server ...
Sinjai's user avatar
  • 121
2 votes
1 answer
2k views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
Michael Dugas's user avatar
2 votes
0 answers
1k views

Include HostName in ODBC System DSN Connection

Not sure if this is a question for here or if it should go on Stack Overflow. If SO is a better fit, please migrate it. Our finance team uses Dynamics GP. Occasionally we need to track the query that ...
Greg's user avatar
  • 3,262
2 votes
0 answers
4k views

SQL Server does not exist or access denied" after installing SSMS

I recently installed SQL Server Management Studio (which also installed SQL Server 2016 to my local machine), and now am unable to connect to SQL Server from applications on my machine. It will come ...
Jordan Johnson's user avatar
2 votes
0 answers
227 views

connecting to a database via tsql on mac 10.10.4

I'm trying to connect to a database via tsql. I use the following command: TDSVER=8.0 tsql -S <server IP> -p 1433 -U <my username> -P <my password> Now, I know the server IP is ...
user1357015's user avatar
2 votes
0 answers
6k views

The underlying provider failed on Open. Error in Windows Service

I have a Windows Service(c#) that receives data and inserts it into DB using Entity Framework 6. Database is SQL Server 2014 Enterprise Edition. Both (Service and DB) are hosted on VPS( Windows Server ...
Ashish Charan's user avatar
2 votes
0 answers
5k views

Getting "Read Timed Out" exception frequently for last few days on my already running SQL Server 2008 R2

Our client has a setup of 2 VMs . One of them has SQLServer 2008 R2 and other has a Java utility which I am using to update the Database.. It was working some time back, but recently it started ...
user3253154's user avatar
2 votes
0 answers
155 views

Turn xact_Abort on for specific applications or user

We have a 3rd party application that requires xact_abort to be turned on, however we have other applications that require it to be turned off. The service that requires it turned on always logs in ...
Greg's user avatar
  • 3,262
2 votes
0 answers
3k views

Cannot connect remotely to a named instance

So, I have two servers (ServerA and ServerB) that I've set up with Windows Server 2008 R2 and SQL Server 2008 R2. My goal is to replicate between these two in a failover fashion (with ServerC as a ...
Nathan C's user avatar
  • 167
2 votes
0 answers
765 views

Linked Server Login Timeout but SqlCmd works

I've got a SQL 2005 SP4 server that connects to a 2008 SP3 instance via linked servers using the SQL Server server type. Every once in a while, one of those linked servers will start throwing login ...
Eric Humphrey - lotsahelp's user avatar
1 vote
2 answers
103 views

Can't connect to named instance from remote server

I have researched a lot on this issue but can't seem to find a solution for it. I have a named instance created on a server but I can't connect using the Servername\InstanceName. I am using SQL ...
kaitlyn's user avatar
  • 583
1 vote
1 answer
1k views

Connection rejected on MySQL server (error 10060)

I have a small database on a server in my LAN that I try to access remotely via ODBC. Currently, I am making a program in Visual Basic to access, retrieve and display data from the server to an Excel ...
SuperRamen's user avatar
1 vote
0 answers
330 views

Windows Suspending PostgreSQL Process

Scenario: Customer’s system VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors) PostgreSQL starts and runs fine for 5 minutes - 2 ...
StillLearnin's user avatar
1 vote
0 answers
111 views

Testing SQL connections with UDL file

I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
mcv110's user avatar
  • 75
1 vote
0 answers
2k views

How to configure the client certificate in Power BI desktop to authenticate with mutual TLS

I am trying to connect to a private data source from Power BI desktop. Data source has its own trusted root authority. I created my personal certificate and private key signed by this root CA. I ...
Parth_patel's user avatar
1 vote
0 answers
6k views

"The client and server cannot communicate, because they do not possess a common algorithm" error

The full error message is: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
boggy's user avatar
  • 427
1 vote
0 answers
206 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 ...
devops's user avatar
  • 23
1 vote
0 answers
2k 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 ...
Marcello Miorelli's user avatar
1 vote
0 answers
93 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 ...
medina's user avatar
  • 197
1 vote
0 answers
1k 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 ...
Peter's user avatar
  • 11
1 vote
0 answers
29 views

Impact of changing server machines names with SQL Server 2016 Standard in mirror state

It's an enterprise network domain. Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
dotnetavalanche's user avatar
1 vote
0 answers
170 views

sqlplus connection to Oracle 11g takes much more time to establish than from another machine

I have an existing Ubuntu 16.04LTS 64bit system that connects to Oracle 11g (11.2.0.4.0 64bit/Windows). From that Linux machine I can connect to Oracle via sqlplus instantly, using sqlplus uid/pwd@...
Gnudiff's user avatar
  • 141
1 vote
0 answers
107 views

sql server connectivity broke down to server after its IP address has moved to a subnet. How to restore its connectivity?

I a server called Vermont on a different domain, with a trust relationship. I can ping the server there. But when I try to connect to it, from my SSMS I get the following error: I used to connect ...
Marcello Miorelli's user avatar
1 vote
2 answers
600 views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm ...
FranciscoRZ's user avatar
1 vote
0 answers
2k views

Service Broker - A previously existing connection with the same peer was detected during connection handshake.

There are good questions about service broker here, here and here. In none of those questions I see the following error message: Service Broker login attempt by user 'MYCOMPANY_USA\sqlservice.' ...
Marcello Miorelli's user avatar
1 vote
2 answers
2k views

SQL Server connectivity without specifying tcp/port

Having connection issues out of nowhere in my lab (Azure VMs): SQL 2016, sp1, cu4 all the way around, Windows 2016 Datacenter Windows Failover cluster for SQL AG testing. SQLServer-0: Default ...
Kevin3NF's user avatar
  • 1,211
1 vote
0 answers
5k views

SQL Server Management Studio times out connecting to a remote SQL Server engine

I've done this at least a hundred times. Install SQL Server on a VPS Install it as the default instance Only install the engine, not SSMS Install Express edition Go to SQL Server Configuration ...
Saeed Neamati's user avatar
1 vote
0 answers
116 views

Database Setup for web application

I am having major trouble setting up up a database for an intranet web application. The users get the following errors: [SqlException (0x80131904): Login failed for user 'XXX\YYYY'.] A few of the ...
007's user avatar
  • 11
1 vote
0 answers
492 views

How to connect to Oracle 11g using Oracle-SQL-Developer from a Mac

I am currently running Oracle 11g on my Windows 10 machine, but I use my mac a lot and I want to connect to the installed Oracle 11g on my windows from my mac using SQLDeveloper. How can you achieve ...
christian Martin's user avatar
1 vote
0 answers
2k views

SQL state S1000 in SQLConnect (but not all the time)

I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
Thijs's user avatar
  • 11
1 vote
0 answers
387 views

Security Concerns ODBC DSN - how well does DSN protect SQL Credentials?

ODBC DSN's have been around for a long time, yet SQL Server still supports them, which says a lot. But I'd like to know, given that this is an older technology, how well are the credentials protected? ...
Sami M. Abbushi's user avatar
1 vote
0 answers
335 views

SQL Server 2014 - remote login to AOAG named instance, listener port does not work

Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors I am unable ...
Debbie's user avatar
  • 303
1 vote
0 answers
1k views

Why is my Redo Log Apply service "spotty"?

I have a 12c Dataguard configuration between apple (primary) and orange (physical standby). The following is my entry in ldap: apple= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(...
exit_1's user avatar
  • 207
1 vote
0 answers
2k views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
Siddharth Trikha's user avatar
1 vote
0 answers
71 views

Unable to connect to PostgreSQL database within pgAdminIII

I have two databases within one Postgres server, and I am unable to connect to one of these databases. Upon a connection attempt, pgAdmin gets hung on "retrieving details on database." I'm able to ...
Jessica Gray's user avatar