Questions tagged [connectivity]
Establishing a connection to a database or database server.
1
vote
1answer
33 views
How to copy all firewall rules and apply them on a new server?
I often install new SQL Server Servers. Be them production, test or development.
There is one thing I still have not automated and it is time consuming: the firewall settings.
I know how to ...
0
votes
0answers
14 views
Can't connect to SSAS server — “Element 'return' was not found. Line 5, position 2.”
I'm trying to access an SSAS server from SSMS v17.4 (2017).
I'm using Windows Authentication.
I know the credentials are correct and can actually connect successfully from Visual Studio 2015.
...
0
votes
0answers
21 views
Connecting to MS SQL Server database via PHP
I’m new to SQL, databases and PHP, and I’m trying to find out the way to query my MS SQL Server database via PHP. I understand I must first establish a connection to the database which is accomplished ...
0
votes
0answers
15 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.'
...
2
votes
1answer
117 views
how to Enable these Windows Firewall rules using powershell?
I have a few servers where I see a blue question mark on the sql server service, as per the picture below.
This is the solution:
Enabling these Windows Firewall rules did the trick for me
...
0
votes
0answers
17 views
Mongodb default setup on Azure - default connect string from local shell
I have a new Azure VM (Ubuntu 18.04.1 LTS) which has docker.
dragam@USDockerVM:~$ IRE> docker --version
Docker version 18.09.0, build 4d60db4
Issued the command
docker pull mongo
this ran ...
1
vote
0answers
24 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 ...
0
votes
0answers
24 views
is there a way to find out what route and endpoint my service broker session is using?
I have been trying in many way, from sys.conversation_endpoints to find out which route and which endpoint my service broker session is using.
SELECT conversation_handle, is_initiator, s.name as '...
0
votes
0answers
30 views
How to disable Oracle OCI client transparent reconnect
I have an application I wrote that uses OCI to connect to an Oracle database. The database has recently been upgraded to Oracle 18, and since then database searches in the application randomly stop ...
3
votes
2answers
393 views
How to access a SQL Server database using another user with permissions in the same intranet
While I'm waiting for my user to get access permissions, I'm stuck using a colleague's, and whenever I try to run basic SQL queries I have to switch from my Windows user to hers.
Hopefully this is ...
-1
votes
0answers
46 views
Flyway 5.2.1 breaks SSL connections to Postgres
We use flyway community version to keep track of schema changes to our Postgres 10.4 DB.
We have enabled SSL on the DB and flyway 5.1.4 was able to connect to it by adding the following line within ...
1
vote
0answers
105 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 ...
0
votes
0answers
12 views
Azure SQL database AAD user can't connect
I've read through the documentation and have tried many, many things to get this to work but am still having trouble.
The AAD user is a member of a group that has been provisioned Contributor ...
0
votes
1answer
81 views
when to use a TCP dynamic port and when TCP Port?
I have a new server that is configured using a dynamic port as you can see below:
The application that connects to this server uses the following connection string, but I am getting the following ...
3
votes
1answer
291 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 ...
1
vote
0answers
13 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 ...
0
votes
1answer
110 views
Microsoft Access is giving me network interrupted errors
We have just upgraded to window 10 and are using Microsoft Access 2016 (16.0.8431.2110) 32 bit.
As a result of this upgrade we now have the issue of intermittent network connectivity issues. My ...
1
vote
2answers
98 views
Odd error when stress testing against an AG
We are running into an odd error when trying to stress test our application that hits an AG. If we point the application directly to the primary server, we don't see any issues with the test. ...
2
votes
1answer
22 views
Connecting to server which located remotely throws timeout exception
Below are the steps which I follow while connecting manually:
Connect to VPN
RDP to the remote machine using my credentials
Open SQL Server Management Studio
Connect to Server > database engine, ...
0
votes
0answers
22 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
27 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
414 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
76 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
103 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
404 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
320 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 ...
4
votes
1answer
144 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
57 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
4answers
4k 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
2k 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
63 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
135 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
202 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
1k 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
155 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
55 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
61 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
92 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
117 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
193 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
511 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
229 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
289 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
271 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
128 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
216 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
213 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
435 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
606 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
396 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 ...
