Questions tagged [connectivity]
Establishing a connection to a database or database server.
0
votes
1answer
17 views
Cannot connect to MySQL using PHP 7 [duplicate]
The version of MySQL is 8.0.16. This is installed on an EC2 Linux and is a fresh install. I have run the mysql_secure_installation command after installation and was able to change the root password ...
0
votes
1answer
26 views
when is it necessary to create aliases in the SQL Configuration Manager?
I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager
I see there are aliases.
I was wonder why ...
0
votes
0answers
32 views
How to resolve an SQL Server “Target principal name is incorrect” error invoked after upgrading from SQL Server 2016 to 2017?
I am experiencing a "Target principal name is incorrect" error after upgrading SQL Server 2016 to 2017. The SQL Server 2016 instance has been uninstalled. The certificate which is registered in SQL ...
0
votes
1answer
33 views
Connect to another host from inside mysql stored procedure
I have two virtual servers on one physical machine.
There are MySQL users and passwords the same for both of them.
I want to write something like this:
SELECT * FROM [host_name].[db_name].[...
1
vote
0answers
11 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@...
0
votes
0answers
18 views
SSIS DB issues when trying to run Package from SSISDB to getch ADO directoty users list
I am working on task that involves using Dev server to fetch ADO directory user information. I am connecting through SQL script i Script task and passing my User authentication. This is working fine ...
0
votes
0answers
40 views
The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount
I get the error message as appears in the title and seen below when running a query against one of our SQL databases. The error seems to be consistent with this specific query when trying to return ...
0
votes
2answers
67 views
Attempting to backup to remote NAS but access is denied
I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the ...
0
votes
1answer
129 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 ...
0
votes
1answer
138 views
MongoDB, Getting Started and Connecting with Compass
I'm trying to connect to my mongoDB running as a service on my rPi3B+, using openSuse Tumbleweed 64bit, mongo version 3.6.2, from my laptop sharing the same LAN/Wifi (pi on LAN & laptop on Wifi).
...
0
votes
0answers
50 views
PostgreSQL disconnection session time
I have a simple app which supports just GET & POST using JDBCTemplate, in tomcat configuration (context.xml) is set where it can find the Database like below:
<Resource name="jdbc/MYDB" auth="...
-1
votes
1answer
19 views
Postgresql 9.6 db connection our Oracle 11.2.0.4. db
I am trying to do a connection between tables/fields between our Postgresql database and an Oracle database. When updates are made in one it needs to be as closely as possible updated in the other, ...
1
vote
1answer
31 views
Source of Entry in Postgres
I want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
0
votes
0answers
33 views
OEM - How to connect as different user?
We can login in OEM using our SSO credential. It is not allowing to display few options. It is throwing error:
Insufficient Privilege
The logged in EM user does not have connect privilege on ...
0
votes
0answers
26 views
Slow connection to SQL Server both locally and by client
Yesterday I was experiencing extremely slow connectivity to the SQL Server with connections via management studio taking 5+ seconds where normally connecting to the server occurs within seconds. This ...
1
vote
0answers
36 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 ...
0
votes
0answers
15 views
Weird Behaviour Aurora Mysql queries Timing out after DB keeps running for a while
I am shifting my database to Aurora Cluster MySQL. For testing, I have created a small sample data (2 GB DB size). I am connecting to the cluster writer endpoint. Connections and queries work fine for ...
2
votes
1answer
38 views
SSIS best practice to allow easily swappable/ secure/ accessible Database Connections?
I come from Pentaho PDI.
There, I learned to have scripts load data to a [VariableDB].
That way, I can either initiate that VariableDB at runtime to "ProdDB" or even set the variable to different ...
0
votes
0answers
44 views
Test connection between application and DB using Oracle instant-client
Good morning
I have on one side an 12.1.0.2 Oracle database server and on the other side an application server which is running Windows Server 2012 R2 Standard.
Client connection to the database are ...
0
votes
0answers
39 views
Always Encrypted returning Timeout error
I am trying to encrypt a number of tables (1 column in multiple tables) in two different databases. On Database A I manage to encrypt these, while on database B it fails with an error: 'Unable to ...
0
votes
0answers
34 views
Can't connect to Postgres through psql in Windows10
I am running psql from Windows command prompt but it is showing error.
I have to change listen address but I don't where it is? Where to find listen addresses in PostgreSQL settings?.
C:\Users\...
0
votes
1answer
92 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 ...
0
votes
1answer
104 views
Can't connect to MS SQL Server via IP address anymore
I'm using a PLC connected to a laptop (over EthernetIP). The development software for programming the PLC has a built in settings page for connecting it to various database engines (MySQL, PostgreSQL, ...
1
vote
1answer
49 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
35 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
40 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
193 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
319 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
37 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
193 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
30 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 '...
1
vote
1answer
59 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
474 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
vote
0answers
298 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
23 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 ...
1
vote
2answers
277 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
710 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
18 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
612 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 ...
2
votes
2answers
193 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
24 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, ...
2
votes
2answers
2k 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
81 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
252 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
576 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
525 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
250 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
1answer
58 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
5k 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
4k 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 ...
