Questions tagged [network]
The network tag has no usage guidance.
176
questions
2
votes
1
answer
88
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 ...
- 121
-1
votes
1
answer
38
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 ...
- 372
0
votes
0
answers
48
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 ...
- 173
0
votes
1
answer
47
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 ...
- 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 ...
0
votes
1
answer
111
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 ...
- 3,056
0
votes
0
answers
139
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 ...
- 119
0
votes
0
answers
25
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-...
- 121
1
vote
0
answers
539
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 ...
- 5,144
0
votes
1
answer
74
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 ...
- 3
0
votes
1
answer
172
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 ...
- 300
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 ...
- 101
1
vote
1
answer
541
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. ...
- 65
0
votes
1
answer
274
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,...
0
votes
1
answer
462
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 ...
0
votes
0
answers
126
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 ...
- 119
1
vote
1
answer
817
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 ...
- 111
3
votes
2
answers
4k
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 ...
- 33
0
votes
1
answer
30
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 ...
- 75
0
votes
1
answer
395
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 ...
- 3
1
vote
2
answers
2k
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) ...
- 13
0
votes
2
answers
114
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 ...
- 1
2
votes
4
answers
459
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 ...
- 945
1
vote
1
answer
932
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 ...
- 15
0
votes
0
answers
62
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 ...
- 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 ...
- 21
0
votes
1
answer
82
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.
...
- 1,019
0
votes
1
answer
532
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 ...
- 81
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?...
- 233
0
votes
1
answer
883
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 ...
0
votes
1
answer
3k
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 ...
- 107
0
votes
1
answer
52
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 ...
- 2,497
0
votes
2
answers
355
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 ...
- 101
1
vote
1
answer
578
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 ...
- 193
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 ...
- 84
1
vote
1
answer
623
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 ...
- 1,213
0
votes
0
answers
237
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 ...
- 13
-1
votes
1
answer
75
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 ...
- 1
2
votes
1
answer
122
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 ...
- 155
0
votes
2
answers
933
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 ...
- 590
0
votes
1
answer
461
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 ...
- 590
2
votes
1
answer
597
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 ...
- 193
0
votes
1
answer
578
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 ...
3
votes
0
answers
283
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 ...
- 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 ...
- 103
0
votes
0
answers
1k
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 ...
- 101
1
vote
1
answer
78
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....
- 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 ...
- 359
-1
votes
1
answer
217
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 ...
- 99
0
votes
1
answer
37
views
Domain Controller on Multi Subnet Always on Availability Group
This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
- 1,019