Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
246 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
Abstract _42's user avatar
3 votes
1 answer
3k views

Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?

My situation is a little bit complicated. I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
cidy.long's user avatar
  • 133
-1 votes
1 answer
65 views

Changing NICs from 1Gb to 10Gb in an availability group

We have a two-node Always On Availability Group set up. Both nodes are on SQL Server 2016 SP3. Primary server has two 1Gb NICs. Secondary has two 10Gb NICs. Both primary and secondary have a default ...
Kris's user avatar
  • 402
0 votes
0 answers
59 views

How to get SQLs per network consumption?

On Db2/Linux_x86 version 11.5.8.0 we have several Db2 instances. With iptraf-ng command sysadmin has noticed that one of this Db2 instance has 20-times more output network traffic then others which is ...
folow's user avatar
  • 303
0 votes
1 answer
81 views

More than 3 Subnets with WFC and Availability Groups

I have a system design where I will have a single WFC node using 2 Server 2016 boxes and a SQL Server 2019 Availability Group. I've followed instructions easily found for setting this up, such as ...
DaveJM's user avatar
  • 3
0 votes
0 answers
7 views

Connect Engine: behaviour on network outage

I am working in an environment with worldwide distributed databases. For the reporting, we use MariaDB Connect Engine to access the remote data from our central site. Sometimes the Network connection ...
DavidRamseier's user avatar
0 votes
1 answer
435 views

Connecting to a remote SQL named instance with named pipe

I found out that when I connect to a remote SQL named instance (ServerA\instanceA) from SSMS installed on ServerB, it does connect without error, but it uses the Named Pipe protocol. I found that out ...
Dominique Boucher's user avatar
1 vote
0 answers
391 views

Why when a Mongodb second secondary node is unreacheable, the cluster is affected?

I have the following MongoDB 4.0.2 cluster with the following information: rs.conf() { IP:192.168.1.26, // Primary, in New York branch priority:10 }, { IP:192.168.1.24, // Second Secondary, in ...
user3637971's user avatar
0 votes
0 answers
38 views

How Turn On Linux Network Port Listeners

I'm on AlmaLinux 9 where I want to host PostgreSQL for the LAN. I've poked a hole in the firewall (firewalld): $ sudo firewall-cmd --zone=public --permanent --add-service=postgresql $ sudo firewall-...
Rich_F's user avatar
  • 121
1 vote
0 answers
760 views

A transport-level error has occurred when receiving results from the server. An existing connection was forcibly closed by the remote host

We have an application in Azure which connects to SQL Server on-premise over hybrid connection Every 4-5 requests from 1000 would fail with error 10054: A transport-level error has occurred when ...
Aleksey Vitsko's user avatar
0 votes
1 answer
131 views

MS Access and multiple users

I'm looking for some help regarding Microsoft Access and database design. I have been developing a database application on Microsoft Access for use in my organisation. I work in a hospital and we have ...
slimn's user avatar
  • 3
0 votes
1 answer
245 views

Is it considered safe to add the public IP of a host to listen_adresses and the pg_hba file?

I have kind of a naive question, but for the moment it's the only way I found to access a local (I mean, located on the host machine) PostgreSQL database from a docker container, so I'm wondering: is ...
s.k's user avatar
  • 342
0 votes
0 answers
38 views

Is it possible to disable DoneInProc tokens in MSSQL Server [duplicate]

I have a PLC library that isn't able to parse the return packet from MSSQL when it includes DoneInProc tokens before the ColumnMetaData and Row data. I've contacted the author of the library, but he ...
Tanj's user avatar
  • 101
1 vote
1 answer
792 views

Does SQL Server require NetBIOS for Named Pipes?

I'm not all that familiar with networking or protocols and couldn't find a similar question here or elsewhere. One of my security people is asking whether SQL Server requires NetBIOS for Named Pipes. ...
DrewCranmer's user avatar
0 votes
1 answer
375 views

RMAN Duplicate PITR without connection to Target database

I would like to understand which network requirements are needed following the least privilege needed policy in order to perform a DUPLICATE DATABASE UNTIL SCN in this scenario My environment is Azure,...
Roberto Hernandez's user avatar
0 votes
1 answer
532 views

Why Federatedx Engine is very slow in MariaDB 10.6 and have to read all the table to get only first 10 rows? [duplicate]

I am trying to get 10 rows from one MariaDB to another MariaDB. However, It takes one and half minute. I have created the table with federated engine pointing to remote MariaDB. Including all the ...
Hector Daniel Bernal Amaya's user avatar
0 votes
0 answers
154 views

mySQL InnoDB tablespace move to network drive

In Windows 10 with mySQL 8.0.26, I am seeking to move a set of rarely used but occasionally necessary tables from my working SSD to another physical device with more space. I have attempted to move ...
wistlo's user avatar
  • 119
1 vote
1 answer
1k views

MariaDB bound to 0.0.0.0, but doesn't appear to be listening to all IPs?

My MariaDB server accepts connections at port 43210 without problems on the public IP address of, we'll say, 123.123.123.123 on eth0. This is on an Ubuntu 18.04 server that also has 192.168.1.10 ...
ylluminate's user avatar
3 votes
2 answers
7k views

Cannot give NT SERVICE\MSSQLSERVER permissions on network drive

I have an SSIS package that I would like to run as a job. The flat file source sits on Server A while the package and job sit on Server B. When I run the job that executes the SSIS package I get an ...
Cody Francis's user avatar
0 votes
1 answer
32 views

VM'd a SQL server, having trouble with external HDDs

First I am not a SQL DB. I inherited an old system and am trying to keep the wheels from falling off. We have an MS SQL 2000 server (running server Win Server 2000) that we performed a P2V migration ...
mcv110's user avatar
  • 75
0 votes
1 answer
544 views

IP Addresses tab is not showing a specific IP Address

I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network interface. I Added a USB MODEM (4G) to the server and went to the IP Addresses tab in network ...
uramium's user avatar
1 vote
2 answers
3k views

The listener supports no services - 2 databases on oracle linux 7

I'm running two 12c R2 databases on linux oracle 7.9 I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
Andrew T's user avatar
0 votes
2 answers
132 views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

(more details/replicate from: https://superuser.com/questions/1612260) Dear all, I'm a total newbie in connecting 2 PCs and making them use the same SQL server DB from one computer ... so please ...
radui's user avatar
  • 101
2 votes
4 answers
598 views

Multi-insert batch executed remotely 5x slower than locally

I am inserting 30.000 rows into a table in one batch using INSERT .. VALUES statement for each row. See the testing environment: Table creation: CREATE TABLE [dbo].[TestInsert]( [Col1] [int] NOT ...
jericzech's user avatar
  • 945
1 vote
1 answer
1k views

Why availability group resource goes offline in WSFC?

Sometimes I find the AG Cluster role in offline state which results the AG in resolving state. It doesn't allow the application to access the databases during this time. And then after sometime it ...
Sree Lekha's user avatar
0 votes
0 answers
84 views

How to increase donor speed on mariadb galera cluster?

hi currently i have database with size 200gb and my every node at 1Gb/s so when 1 node is down and then 2 node will be donor i config mariadb donor with wsrep_sst_method = rsync method. but it's take ...
febry's user avatar
  • 47
2 votes
0 answers
2k views

Sql error number: 1236. Error Message: A transport-level error has occurred when receiving results from the server

I'm getting a SQL Server error: Execution fail against sql server. Sql error number: 1236. Error Message: A transport-level error has occurred when receiving results from the server. (provider: TCP ...
Vuong Nguyen's user avatar
0 votes
1 answer
96 views

Web server accessing the database server in Always on availability group

We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
SQL_NoExpert's user avatar
  • 1,019
0 votes
1 answer
676 views

Making an Oracle XE instance network wide available

Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
SweetPotato's user avatar
13 votes
3 answers
4k views

Disconnect from network without stopping the query

I have an opposite problem to Does disconnecting the network stop a query?. I would like to launch a query and disconnect without waiting for results but I don't want the query to stop. Is it possible?...
YuseqYaseq's user avatar
0 votes
1 answer
1k views

How to use BCP Utility queryout in a network path with crededential (login required) for SQL Server

I'm having a hard time figuring out on how can I export my selected table in a network path that requires login credentials. 'bcp "select ''StudentName'' UNION ALL SELECT StudentName AS ...
Lawless16's user avatar
0 votes
1 answer
4k views

What is the max network latency between synchronous-commit AlwaysOn Availability Groups [closed]

Is there a maximum supported network latency (ms) between two synchronous AlwaysOn replica? I need to give this information to network administrators for configuring the link between the two nodes of ...
Gio's user avatar
  • 107
0 votes
1 answer
55 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
Manngo's user avatar
  • 2,709
0 votes
2 answers
465 views

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured. Consider that the leader node crashes. Two ...
Pedro Lopes's user avatar
1 vote
1 answer
782 views

PostgreSQL: Save roundtrips / Network performance

For my work I often have to to large selects loading a lot of data. The connection happens with JDBC driver and high fetch size. This is not a problem when working directly on the server of the ...
beginner_'s user avatar
  • 213
3 votes
0 answers
2k views

DNS CNAME for a SQL Managed Instance (Azure)

I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server. I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
Lickrob's user avatar
  • 84
1 vote
1 answer
717 views

Why changing the order of network protocols does not make any sense?

All I want to do is to connect to SQL Server though Named Pipes without using an explicit way like NP:ServerName because mentioned approach works. I want to connect through Named Pipes using just ...
Rauf Asadov's user avatar
  • 1,243
0 votes
0 answers
285 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
Geo_explorer's user avatar
-1 votes
1 answer
89 views

Connecting database from another network [closed]

We have a database in our server at work, and we can connect the database if we are connected to same network with server. I want to connect from my home. How can I do this? I have tried couple of ...
ridley13's user avatar
2 votes
1 answer
145 views

Troubleshooting high network traffic between primary and secondary replicas

We have two SQL server hosts. There are about 12 availability groups, where the primary replica is on the "primary" host and the secondary replicas are on the "secondary" host. Now, for one reason or ...
AlexMayle's user avatar
  • 155
0 votes
2 answers
1k views

ASM - How the asm search the disks and where is this parameter from?

I'm a begginer in Oracle ASM and when I will create a diskgroup the ASM shows me this parameter: Where is this parameter from? I don't remember set any parameter with this name. I know that usually ...
Potter's user avatar
  • 550
0 votes
1 answer
624 views

Oracle - Why create several service_name in service_names parameter?

SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener ...
Potter's user avatar
  • 550
2 votes
1 answer
679 views

Need SQL Server VLAN advice.. is it best practice to have all SQL Servers under 1 VLAN/network zone? [closed]

Looking at the network placement of my SQL Servers. Looking for answers: Is it a best practice to have all SQL Servers in 1 or 2 VLANs within your businesses network? however, if so, wont there ...
Daniel Nash's user avatar
0 votes
1 answer
705 views

Two physical servers with sql server on same network

IS there a way I can remotely access sql server DB having two different servers in the same network/public IP? The first Server is configured to listen to 1433 port but we make the connections using ...
Pedro Cury's user avatar
3 votes
0 answers
312 views

TCP Resets when using psycopg2

I'm trying to do a simple health check for keepalived and other services via a python script and psycopg2 library. All seems to be alright, until I close the connection, at which point a packet with ...
JPm's user avatar
  • 31
0 votes
2 answers
2k views

How to connect to sql server with dynamic IP Address

I have installed sql server express edition 2014 on my machine. And I am connecting to it with CRM using my local machine's IP address. The problem here is my IP address allocated to my machine is ...
JavaStudent's user avatar
0 votes
0 answers
2k views

Help with Connecting to SQL Server using Oracle SQL Developer

I am trying to connect to SQL Server using Oracle SQL Developer. I was able to get the SQL Server JDBC installed on SQL Developer and am able to see the SQL server Tab on the Connections page. I have ...
Sidhu177's user avatar
  • 101
1 vote
1 answer
83 views

Multi-Subnet AlwaysOn: Is Routing and Remote Access always required?

Context I'm setting up a 2-node AlwaysOn Availability Group (SQL Server 2017 Enterprise) with the following setup: Existing DC+DNS (One NIC: 10.20.11.1/255.255.254.0) New AG-Node1 (One NIC: 10.20....
dsuy's user avatar
  • 420
6 votes
2 answers
2k views

Are CNAME aliases for connection strings a good idea?

To be very flexible and move database to different servers more easily, we came up with the idea of using an alias per database. So by simply changing a DNS entry, we can route all queries to a ...
SwissCoder's user avatar
-1 votes
1 answer
254 views

How to use mariadb instead of sqlplus using sqlnet configuration files

currently I can access a database on a remote server using Oracle's instant client "sqlplus" The connection is dependent on a couple of configuration files in: $ORACLE_HOME/network/admin which are ...
aghsmith's user avatar