Questions tagged [network]
The network tag has no usage guidance.
34
questions with no upvoted or accepted answers
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" ...
3
votes
1
answer
906
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 ...
- 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 ...
- 84
3
votes
0
answers
295
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
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 ...
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
2
votes
0
answers
74
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 ...
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 ...
- 512
2
votes
0
answers
520
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 ...
- 171
2
votes
2
answers
217
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 ...
- 111
2
votes
1
answer
829
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 ...
- 1,342
1
vote
0
answers
265
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 ...
- 129
1
vote
0
answers
631
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,182
1
vote
1
answer
919
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
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 ...
- 15
1
vote
1
answer
643
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 ...
- 213
1
vote
1
answer
64
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 ...
- 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 ...
1
vote
0
answers
250
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 ...
1
vote
0
answers
195
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 ...
- 45
1
vote
0
answers
98
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 ...
- 1,692
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 ...
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 ...
- 777
0
votes
0
answers
16
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 "...
0
votes
0
answers
55
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 ...
- 183
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
0
answers
32
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
0
votes
1
answer
314
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
0
answers
131
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
0
votes
0
answers
73
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
0
votes
0
answers
255
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
0
votes
1
answer
636
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 ...
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 ...
- 101
-1
votes
1
answer
232
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