Questions tagged [network]

The tag has no usage guidance.

36 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
0 answers
3k views

Once more about SQL Server virtual accounts

Let me reboot my question on SQL Server virtual accounts permissions The (same) MSDN article on the same version 2012 of SQL Server "Configure Windows Service Accounts and Permissions" ...
Gennady Vanin Геннадий Ванин's user avatar
3 votes
1 answer
7k 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
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
3 votes
0 answers
327 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
3 votes
0 answers
3k 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 ...
The Great Laughter's user avatar
2 votes
0 answers
34 views

MySQL Client taking more than 14 sec to be connected

IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
Basudev Rout's user avatar
2 votes
0 answers
3k 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
2 votes
0 answers
104 views

How to set up SQL Server online with public Wi-Fi

I am doing a school project where I have to set up a SQL Server database for my teammates to work on. Currently, I am able to host the server online with my home router, but I am facing problems ...
Christopher Tan's user avatar
2 votes
0 answers
268 views

How to avoid Network issues for SQL Server 2012 AlwaysOn

I have SQL Server 2012 and have setup AlwaysOn for High Availability. The infrastructure is on Azure VM's. After moving to this setup, we are frequently observing Network issues which either causes ...
MySQL DBA's user avatar
  • 512
2 votes
0 answers
534 views

Networking (classmate like) website database model

I am working on a project that consists in building a networking website like the Classmate web site. I have proposed a database model based on the social media database model presented on the ...
cProg's user avatar
  • 171
2 votes
2 answers
225 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

I have put this question on serverfault.com as well, but since the problem concerns connecting to SQL Server, I will also put it here. We are trying to migrate an Axapta 2.5 database from SQL Server ...
Carsten Hynne's user avatar
2 votes
1 answer
891 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
GSerg's user avatar
  • 1,342
1 vote
0 answers
57 views

SQL Server unexplained network traffic gaps in traced events

This appears to have started happening a week, maybe two weeks ago. Essentially, we cannot figure out whether it is the server or the client that is periodically pausing between SQL statements. In the ...
孔夫子's user avatar
  • 4,330
1 vote
0 answers
489 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
1 vote
0 answers
849 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
1 vote
1 answer
2k 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
1 vote
1 answer
996 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
  • 211
1 vote
1 answer
68 views

One instance, four clients, one is slow

We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database is hosting files for our accountant software. This is a multi module software that runs ...
jarle 's user avatar
  • 11
1 vote
0 answers
21 views

Problem about listing network instances on SSMS

I have a problem about listing network instances on SSMS. When I look at the Network Instances on SSMS, it shows only local server instances. By the way, it shows all the instances on the network ...
Onur Eryilmaz's user avatar
1 vote
0 answers
278 views

How can I forward odbc/oledbc connection through DMZ

I have an Oracle database separated from our BI system by two network zones (different sides of a DMZ). Company policy dictates that firewall openings may only pass to an adjacent zone. Therefore it ...
Axel Burström's user avatar
1 vote
0 answers
234 views

SQL Server and Network considerations to transfer backup file to a shared folder

I'm facing with a situation where backups are being transferred manually to a Shared Folder and my goal is to optimize all of this. What I have to deal with is: 8 Windows 2008 R2 Servers 2 Windows ...
BlackStar's user avatar
1 vote
0 answers
101 views

Slow query speed using workstation processed joins with 100 Mbps connection speed?

In a department where they were complaining that a report was being run slowly, I jumped on one of the empty machines there and tried it out. It took a good 6 and 15 seconds to run. Run from a ...
leeand00's user avatar
  • 1,702
1 vote
0 answers
36 views

Sync job issue, maybe network related?

I have a job that syncs rows in a table between a production server and four other servers. The problem is the job runs perfect on three servers, taking less than 2 seconds. On the fourth server, it ...
Alexis Mineros's user avatar
1 vote
0 answers
43 views

Postgres with no clients still chatty on network

This may be a non-issue but I was doing some network monitoring on my Mac and noticed that PostgreSQL (9.4.4) was still sending and receiving packets even when I'm not aware of any clients (localhost ...
Meltemi's user avatar
  • 777
0 votes
0 answers
72 views

Cannot connect to PostgreSQL DB over a Virtual IP (VIP)

I am running a PostgreSQL DB Server v12.16 on an Ubuntu 20.04 virtual machine. When I attempt to connect to DB directly from host, it WORKS! When I attempt to connect to DB via the VIP, it DOESN'T ...
user3051574's user avatar
0 votes
0 answers
39 views

Why, MariaDB user allowed host IP address also allows a virtual machine on the host with NAT network adapter

The MariaDB user specifies an allowed IP address in the Host column of the mysql.user table. So, it only allows logging in from the host with the specified IP address. And MySQL has the same design. ...
James's user avatar
  • 149
0 votes
1 answer
406 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
0 votes
0 answers
69 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
  • 339
0 votes
0 answers
39 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
  • 131
0 votes
1 answer
457 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
0 answers
179 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
0 votes
0 answers
95 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
0 votes
0 answers
306 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
0 votes
1 answer
796 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
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 votes
1 answer
279 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