Questions tagged [connectivity]
Establishing a connection to a database or database server.
400
questions
2
votes
2
answers
3k
views
SQL Server : cannot add subscriber to publication
I am trying to configure replication as per the official tutorial from Microsoft. In the section Create a subscription to the transactional publication, see step 5.
The name of the subscriber ...
2
votes
1
answer
2k
views
Can't connect to a remote server using phpMyAdmin
I tried with two different servers, one had no issue but the other gave me this error:
MySQL said:
Cannot connect: invalid settings.
mysqli_real_connect(): The server requested authentication method ...
0
votes
1
answer
2k
views
Can't connect with UDL file to SQL Server 2016 but with SSMS it works without problems
I have a strange issue using a UDL file.
I can't connect with the UDL file to SQL Server 2016 with a specific user (login) but when I'm trying to connect with the same user via SSMS, it works without ...
5
votes
1
answer
1k
views
Static DAC ports for named instances
Using SQL 2016 Enterprise Edition
The default instance will listen on 1433 and the DAC port will listen on TCP 1434. SQL Browser will listen on UDP 1434. Any subsequent named instances will get a ...
-1
votes
1
answer
63
views
Connecting to SQL Server [closed]
I am new to SQL Server. I need to connect to a SQL Server that is running on another machine.
Which tool do I need to install on my Windows 7 laptop to connect remotely?
3
votes
6
answers
49k
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
1
answer
31k
views
Where is MSOLEDBSQL provider driver? "The 'MSOLEDBSQL' provider is not registered on the local machine."
This has been going on. At first MS said they will not support TLS1.2 for OLEDB then they said, they will. You can read about it here, where they said, the support comes in March 2018
Now it looks ...
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 ...
4
votes
1
answer
2k
views
Determine which SQL drivers an application uses to connect to SQL server
I want to find out what SQL driver a third-party application (or any application for that matter) uses to connect to a SQL Server instance in production. It can be tough to get a fast answer from a ...
3
votes
1
answer
7k
views
Connection issues with Azure DB from SSMS
I am currently making a connection to Azure DB from SSMS using public wifi. For the past few days, I was able to connect SSMS to Azure DB without any issues by adding the current ip address into the ...
-1
votes
2
answers
2k
views
Connection string throws a SqlConnection Error [closed]
my connection string:
SqlConnection con = new SqlConnection("Data Source=ANUPAM-DESKTOP\ANUPAM;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;...
3
votes
2
answers
860
views
Do applications have to specify TCP: in the connection string to availability group listeners?
In articles that I have read about applications accessing databases through the availability group listener, they all seem to want to use TCP: prefix before the listener name in their connection ...
0
votes
1
answer
2k
views
Why my Oracle 12c database seems not to be started?
I have installed an Oracle 12c database on my development environment, which I start only once a while for integration testing. But today, it does not seem to start, or did it start but does not allow ...
2
votes
2
answers
531
views
SQL Server, odbc newbie question
My new job has some sql server 2014. I am an Oracle DBA.
I need to help a client.
They are having issues creating the ODBC connection from their laptop to the database server (or whatever MS calls ...
1
vote
1
answer
2k
views
Can't connect to Database Engine
I just built a server (SQL 2017) and I can connect to Analysis Services and Integration Services via SSMS without issue using Windows Authentication.
When I try to connect to the Database Engine I ...
0
votes
1
answer
845
views
Oracle JDBC TLS connection fails (handshake_failure) after OS upgrade
I have an Oracle Database 12.1 server running on Oracle Linux 6.
Secure (TLS) connections were working fine until I decided to update the underlying operating system (yum update) and reboot the ...
0
votes
1
answer
4k
views
Error connecting to the server:FATAL:couldnot open file"base\12135\11946":No such file or directory
I have a issue from PostgreSQL 9.4 .The issue is given below:
An Error has occurred: Error connecting to the server:FATAL:could not
open file"base\12135\11946":No such file or directory.
This ...
0
votes
1
answer
744
views
Galera Failures
I have 2 nodes. One a VPS on NFO Servers and another on Azure. I have setup the firewalls/disabled the firewalls. The nodes are CentOS 7, Latest Kernel. The configs are as follows:
Node 1 (Master DB)
...
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, ...
0
votes
3
answers
1k
views
cannot connect my oracle server to developer
I get the following error: Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. ...
2
votes
2
answers
9k
views
Oracle - Connecting as a proxy user via connection string
I have been granted access to a specific schema in an Orale database via a "proxy user" / "connect through" .
In SQL Developer / TOAD, I give my username as "MyUser[SomeSchema]", and after login I am ...
3
votes
1
answer
1k
views
Postgres occasionally slow to query
I'm running a database with a few tables with large row counts (millions) but which are fairly small in data size. All the tables are append-only, so no deletes or updates ever happening, around 250 ...
0
votes
1
answer
2k
views
SQL Server - "The connection must be in an opened state."
I run various queries against a SQL Server 2012 instance, and occasionally, the following error message will pop up:
The connection must be in an opened state.
Parameter name: connection (...
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 ...
3
votes
2
answers
15k
views
Unable to connect to remote SQL Server instance after thorough troubleshooting
I am at the end of my rope troubleshooting a remote SQL Server connection problem. I am a DBA but not a networking expert.
Certain information below has been sanitized using "x" in place of a letter.
...
3
votes
1
answer
3k
views
Difference between Session Timeout and Heartbeat in always on
What is the difference between Session Timeout and Heartbeat in always on...
My Network is laggy and i get frequent connection timeout error on error logs and also at the I see missed heartbeat errors ...
2
votes
2
answers
1k
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 ...
-2
votes
1
answer
2k
views
MongoDB Sharding Configuration
I am trying to setup a sharding on Windows Server 2008 R2. I have a batch file in which i added the following commands:
When I try to connect to mongos with the default port, I get an error
(unable ...
6
votes
1
answer
7k
views
Connection Timeout Expired without apparent network issue
We have one particular SQL Server which is intermittently timing out when accepting connections. The issue is consistent throughout the day, but occurs at a very low incidence. How can I continue to ...
1
vote
1
answer
656
views
Periodic connection failure on SQL Server 2012 AlwaysOn cluster
Since last wednesday (so a we're dealing with this for a week now) we're getting periodic connection problems on our production database cluster. (An alwayson cluster running on windows 2012, three ...
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 ...
0
votes
1
answer
6k
views
SSIS 2016 Access Denied
I followed below steps after SQL Server and Integration Services, but I am still getting an error.
I added SQL service account in Microsoft SQL Server Integration Services 13.0 properties which is ...
0
votes
2
answers
10k
views
Unable to connect to MySQL on Windows 10: Access denied for user
I have MySQL server (only the server) installed and running on my Windows 10 computer. I tried to connect to the server with the following commands:
mysql -u root -pSql2017
mysql -u root
mysql --...
4
votes
1
answer
4k
views
Setting connection properties (application_name) for Postgres connections
I want to attach an application name to my connection like PgAdmin does here:
(Query in text form: select pid,query,wait_event,state,* from pg_stat_activity;)
My connections are created this way (...
11
votes
1
answer
4k
views
Connecting to a local MS SQL Server from a GUI client
I am very new to SQL and database servers. I have recently been using SQL Server Express and accessing my database using SQL Server Management Studio on Windows. I am now trying to achieve a similar ...
1
vote
1
answer
4k
views
Can't connect to PostgreSQL instance using Python
I have installed vagrant and virtual box on my laptop to finish a class I am working on. I have created a database called tournament. I can connect to it directly, create tables, insert data, etc.
...
1
vote
2
answers
32k
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....
11
votes
1
answer
16k
views
Reconnect "not connected" query windows in SSMS to original connection
Is there a simple way to reconnect a query window that is "not connected" to the original connection that was used by that query without manually picking the server name needed? If I click the Connect ...
0
votes
1
answer
99
views
Oracle Developers guide 10g is not connecting to server [closed]
I have installed Oracle developer's guide 10g on Windows 10; it installed successfully.
While connecting to Oracle EBS host data base it give an error.
Entered detail on connection screen:
User - ...
0
votes
1
answer
141
views
Cannot connect from elsewhere than a console
I am quite a beginner with MySQL, but I already got problems with setting up a connection. I tried to use MySQL Workbench, but I can't connect to the server. I use SparkyLinux, a Debian-based ...
5
votes
1
answer
6k
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
1
answer
152
views
How to add data to sql server using MS access front end, when user will not always have sql connection
I have a SQL Server backend and an Access Front end database which is working fine.
However, I now have a user that needs to use this database (on a tablet) for some equipment checks out in the ...
2
votes
1
answer
8k
views
Connection reset to SQL Server when using SSH Tunnel
I am trying to connect to an MS SQL Server database through DBeaver via an SSH tunnel but am getting the following error message when I "Test Connection...":
I/O Error: Connection reset
...
7
votes
1
answer
49k
views
Connect to SQL Server over Internet
I want to connect to SQL Server via Internet:
I turned off the firewall
I enabled the the DMZ in the router, host address is 192.168.1.24 which is the SQL Server LAN IP
I open port in the router for ...
5
votes
1
answer
1k
views
SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?
We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description:
We have SQL Server 2014 (and 2016) ...
2
votes
1
answer
556
views
Application unable to connect after doing a failover ,Mirroring
After doing a failover to mirror database, the application is throwing below error
Login failed for user 'NT Authority\anonymous logon'. reason: could not find a login matching the name provided
In ...
5
votes
1
answer
1k
views
SQL Server 2016 Availability Groups Named Pipes?
We have a SQL Server 2016 cluster configured (two VM's) with our databases spread across multiple Availability Groups (AG).
Our Sharepoint admin is reporting to me that some functionality is failing ...
0
votes
1
answer
10k
views
A connection cannot be made. Ensure that the server is running
I have 2 PCs at home: Win10 with SQL Server 2016 and Win7 with SQL Server 2014.
Both servers are installed in Windows Authentication mode. I have set up users with the same name on both PCs.
I can ...
2
votes
0
answers
565
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 ...
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 ...