Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Establishing a connection to a database or database server.

0
votes
0answers
14 views

Insufficient privileges issue when creating connection to Oracle from Replication Server

I am trying to setup a replication between Sybase (primary) to Oracle (Replicate) server. I have already setup a RepAgent and create an Oracle connection as follow:- create connection to PUB1.POLY ...
0
votes
0answers
15 views

PostgreSQL database timeouts with high timeout value, but works fine with lower value

Our website uses pg_connect while connecting to a database. After doing some tweaking we increased the value connect_timeout from 3 to 7 seconds. We started seeing timeout expired exceptions. Then we ...
2
votes
1answer
40 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 ...
0
votes
2answers
64 views

Users who are connected into the database

I need some help on how to find all the users that are connected to one of my database. I should check this on weekends to find out all the users that connected during the week. Thank you.
2
votes
2answers
47 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 ...
1
vote
1answer
75 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 ...
0
votes
1answer
73 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 ...
2
votes
1answer
58 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 ...
-2
votes
1answer
52 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?
1
vote
3answers
1k 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 ...
1
vote
1answer
843 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 ...
0
votes
1answer
46 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 ...
1
vote
1answer
71 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 ...
0
votes
0answers
85 views

How to switch OFF autocommit in a powershell ODBC connection to Postgres

I have an automated powershell script adding records to a postgres database and I’m attempting to improve the performance. Currently my connection is defined as…. $DBConnectionString = "Driver={...
0
votes
1answer
409 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
vote
0answers
106 views

SSMS Losing Connection | Connection Timeout [closed]

Problem statement: Observing several remote SSMS connection retry after some interval. (Connection Timeout expired) Workarounds: We have changed the remote query timeout to 0 (Disable Timeout). We ...
-1
votes
2answers
46 views

Connection string throws a SqlConnection Error [closed]

I gave the copied string: SqlConnection con = new SqlConnection("Data Source=ANUPAM-DESKTOP\ANUPAM;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;...
2
votes
1answer
31 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
1answer
49 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
2answers
80 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 ...
0
votes
0answers
109 views

Postgresql DB won't allow connection after power outage

There was a power outage yesterday, and now I cannot connect to my local postgresql db server. I'm running Windows 7. I receive the following error whether I attempt via cmd, pgadmin4 or other scripts....
1
vote
1answer
253 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
1answer
155 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
1answer
167 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 ...
2
votes
0answers
196 views

Cannot telnet ipaddress 1433 on a particular server. (Other servers are able to though) [closed]

The background: Currently I am working on website migrations from an old server (A) to new server (B). While doing so, I discovered an issue on server B. I am not able to connect to the SQL Server ...
0
votes
0answers
67 views

Disconnections in SQL Server

I'm looking for some suggestions regarding a disconnection issue, I'm basically looking for a way to track why the connections are getting dropped that suddenly. The application is using tomcat and ...
0
votes
1answer
140 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) ...
1
vote
0answers
130 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
3answers
218 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. ...
1
vote
2answers
332 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
1answer
302 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
1answer
55 views

SQL Server refuses to connect from time to time

I get this error like 5 times a day. It does not happen always and we cannot really reproduce it. So is there any common knowledge as to why SQL Server sometimes refuses to connect and sometimes ...
0
votes
1answer
231 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 (...
1
vote
0answers
220 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 ...
0
votes
0answers
78 views

Issue creating connection to Oracle in Sybase Replication Server

I am trying to setup a replication between Sybase (primary) to Oracle (Replicate) server. By doing this, I have setup a RepAgent and create an Oracle connection as follow:- create connection to PUB1....
3
votes
2answers
859 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. ...
1
vote
1answer
376 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 ...
0
votes
1answer
148 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 ...
4
votes
1answer
915 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
1answer
203 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
0answers
541 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
1answer
1k 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
2answers
1k 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 --...
0
votes
0answers
64 views

Random AG disconnect with no cluster event recorded

I had this happened to a couple sets of AGs on different servers. Out of nowhere I could get messages like these, sometimes once a day, sometimes multiple times a day. For example, SQL 2012 on ...
4
votes
1answer
655 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
1answer
1k 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
1answer
449 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
1answer
3k 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

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
1answer
55 views

Oracle Developers guide 10g is not connecting to server

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 - ...