Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [network]

The tag has no usage guidance.

1
vote
1answer
39 views

Cluster IP's under Access Point for Administering the Cluster

When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for the public subnets, or do we also need to include an IP for the private subnet(s)? This ...
1
vote
1answer
33 views

Why does a query on a local instance with local database files cause NETWORK_IO waits?

I have followed this tutorial to get the wait stats of a particular query while it is 'in flight' using extended events. Whilst the tutorial refers to an index rebuild, I just did a select statement ...
3
votes
1answer
196 views

What ports does SQL Server use on Linux?

What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
0
votes
0answers
14 views

Bizarre MySQL Replication Connection Issue

I am configuring MySQL master-master replication (AKA master-slave replication done twice) between two servers. After I set the master settings on each server (CHANGE MASTER TO master_hos..., etc.) ...
1
vote
1answer
45 views

Disabling IPV6 on Always on availability group

In our environment we only have one network adapters for the Replicas and IPV4 is being used. By default the IPV6 is also enabled. My question is will there be any problems if I unchecked IPV6 from ...
1
vote
0answers
21 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 ...
2
votes
1answer
20 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
0
votes
0answers
28 views

Remotely access a database not public to Internet

I am looking for a way to remotely edit a Microsoft SQL database running on Windows 7 and that is not public to the Internet. Right now I am using TeamViewer to do this but is really bad. The reason ...
0
votes
1answer
69 views

Cannot connect to SQL server through SSMS from other machine after IP change [closed]

There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally . The firewall is disabled on the server and moreover its listening on port ...
0
votes
1answer
37 views

Difference between an endpoint and a port in SQL Server

While I know why are ports used in SQL Server, I wonder what is the difference between an endpoint and a port. Ports can be managed using Configuration Manager, is it also possible to manage endpoints ...
1
vote
1answer
280 views

Which TCP port to choose for SQL Server to listen to for security reasons? [closed]

I know that the default TCP port for MS SQL Server is 1433 and it is better to change that for some security reasons. But I want to know which port is better to choose instead of 1433 for SQL Server ...
1
vote
0answers
17 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 ...
0
votes
0answers
78 views

Why does a scheduled SQL Server agent job fail when the proxy domain account is idle?

I have an SSIS package scheduled to run with an sql server agent using a proxy with my domain credentials. It imports data from a file dropped on a network drive that I have access to. The scheduled ...
0
votes
0answers
66 views

Netbackup for Oracle RAC 11.2 and virtual names

We are trying to configure our backups with NetBackup for a 2 node Oracle Database RAC 11gR2. Documentation (Here) about RAC configuration is very short, and I don't understand very well how to ...
3
votes
2answers
365 views

Will matching SQL Server network packet size to mtu increase performance

We have recently upgraded our production facility to sql server 2017, and moved to clusterless availability groups. There is a primary, a secondary on site, and a remote secondary. We were ...
7
votes
1answer
92 views

Multi-homed SQL Server with High Availability Groups

We have two servers (SQL-ATL01, SQL-ATL02) that make up a Failover Cluster, each running as part of a SQL Server High Availability Group (HAG). Each server has two network cards. One is a 10Gbit card ...
1
vote
1answer
315 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 ...
4
votes
1answer
123 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 ...
2
votes
1answer
77 views

Dynamic Ports are being set to different ports

On one of our instances of SQL Server (12.0.5571.0 if you really need to know) we use multiple IP addresses to connect. 127.0.0.1 - Dynamic Port set to 0. No static port set 172.16.0.5 - IP Address ...
0
votes
1answer
37 views

Is it possible to redirect queries to another server?

I want to set up a server that redirects queries. It would receive incoming SQL Server traffic, redirect to the actual SQL Server, and return results back to the client. Is this possible? What are ...
0
votes
0answers
44 views

Can I use TDS compression with Azure SQL DB or Managed Instances?

Currently, we have our data warehouse running on an Azure VM. We have NitroAccelerator installed there and on our client machines. Our analysts pull large data sets into Tableau, R, SSMS, etc. By ...
2
votes
2answers
1k views

Full Back up over to Network failed due to unknown network error 59

I am recently seeing the Unknown Netowrk Error 59 which saves the full back ups to a file share on some of the servers . The back ups happens at different times. Ola Halengren scripts are being used ...
2
votes
0answers
51 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 ...
1
vote
1answer
42 views

Cluster Validation on Remote Node

I have a 3 Node always availability group: 2 Nodes are In house – Synchronous Mode. 1 Node is remote - Asynchronous Mode. Every now and then the Remote Node loses connectivity and goes offline ...
0
votes
0answers
34 views

Connect to a MariaDB database cluster from a clinet on a different subnet

I have three servers where each one of them has two Ethernet interfaces namely eth0 and eth1. I have set up MariaDB server galera cluster with three servers with IPv4 addresses 192.168.1.100, 192.168....
0
votes
1answer
79 views

Hostname configuration for oracle12c on OL7 VM

I am trying to install Oracle 12c (for learning/studying purposes)on a VirtualBox VM. i have set up a VM with Oracle Linux 7.4 and when I setup the wireless/networking aspects during installation I ...
0
votes
0answers
189 views

Eliminating PostgreSQL/database network latency: PL/Java stored procedure VS. Java code running on localhost

A couple years ago, I learned the hard way that having my Java application sitting on one server, with the database sitting on another, and having complex transactions that issue lots of queries each, ...
1
vote
0answers
414 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 ...
0
votes
0answers
30 views

Amount of data being transfered over

Is there any way that when an Application make a call to a database to see the amount of data(in KB/MB) transferred over the network in reply to that call. We have been told that when the ...
2
votes
1answer
307 views

MariaDB Galera stop working without network connectivity

I am running MariaDB Galera cluster whose using mariaDB and 3 nodes(node A, node B, node C). My nodes are placed locally in our office. My problem is if node A/B/C lost network connection, it also ...
0
votes
1answer
563 views

SQL Server Error - The connection is broken and recovery is not possible [closed]

I have a .NET application that connects from A Windows 10 client to an SQL Server 2016 Express database running on Windows Server 2012 R2. Whilst a connection is successfully established, it is ...
10
votes
2answers
2k views

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

In our environment the network storage is low on space. At the same time I would like to make sure that we take transaction log backups every 15 minutes instead of current every 6 hours. My question ...
0
votes
1answer
49 views

Find ClientHost using ClientIP - SQL Server 2014

Recently we started getting alerts as below : EventID 18456 - Login failed for user 'abc'. Reason: Could not find a login matching the name provided. [CLIENT: xx.xx.xx.xxx] EventID 17828 - The ...
1
vote
1answer
655 views

Difference between Session Timeout and Heartbeat in always on

What is the difference between Session Timeout and Heartbeat in always on... My Network is laggy and i get frequent connection timeout error on error logs and also at the I see missed heartbeat errors ...
2
votes
1answer
114 views

How to verify (CHECKSUM or MD5) dataset you received over a network?

I will remotely query mysql database and I want to check that the received dataset matches the table in the host computer. How do you do that? I am fairly new to sql database. I know of Checksum and ...
0
votes
1answer
465 views

How to configure port for listening to traffic meant for PostgreSQL

When setting up postgreSQL with a webserver (all on the same machine), is it critical to have 0.0.0.0:5432 open, or is just 127.0.0.1:5432 enough? Why or why not? Overall, I'm trying to understand ...
0
votes
1answer
917 views

MongoDB Replication - “Failed with No route to host”

Hi, Running MongoDB version 3.4.9 on two separate servers running Centos 7. Trying to add a create a replica set but when ever I try to add a second server I get this error: devshardcfgrs:PRIMARY> ...
1
vote
0answers
87 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 ...
0
votes
0answers
976 views

Cannot connect from Linux to Windows SQL Server with FreeTDS

On the Windows side, SQL Server has been configured to allow TCP connections on port 1433, IP 192.168.33.1. It is active and enabled I have turned off the firewalls on both the Linux and Windows ...
0
votes
2answers
2k views

Permission denied with Copy command when using network share

I am running the following Copy command via npgsql (.Net) from a client on the network: COPY work_narcra00_2017_q2.a2_aevent FROM '//BRAHMA//EnvironProcessing//dbprocessfixedasciiimport.tmp' WITH ...
2
votes
0answers
319 views

SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?

We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description: We have SQL Server 2014 (and 2016) ...
5
votes
2answers
703 views

PostgreSQL network compression for result set?

I was reading about network compression with PostgreSQL to see if there was anything that offered that which would permit big result sets to transfer over the wire to remote web servers. It seems ...
9
votes
2answers
309 views

Is network traffic encrypted when writing remote backups using SQL Server TDE?

They do say there is no such thing as a “stupid question”, so here goes: I understand that SQL Server Transparent Data Encryption (TDE) encrypts data at rest, so that your database files (.mdf) and ...
0
votes
0answers
206 views

Friend network database schema

I came across the structure of some code in a project that I'm working on & I'm not sure why it's structured this way. Basically what we want todo is store who is friends with who in our ...
0
votes
1answer
40 views

Availability groups taking time to change states

I created a 2 node AG setup as a POC today and when I tried to do an automatic failover by stopping the sql server service on the primary node, the one in the secondary went into resolving state and ...
3
votes
1answer
185 views

How fast can I pull data through a SQL Server client connection?

What is the highest throughput possible? Has anyone seen anything above 25MB/sec? I've been trying to figure out what is even possible. I know there are tuning parameters like packet size, and rows ...
2
votes
1answer
4k views

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee ...
0
votes
1answer
80 views

IP configuration for MultiSubnet AAG setup

Is it a good practice to have all the ip's in a different subnet for an AAG setup as mentioned in the link below? When I wanted to setup a 2 node AAG, the windows team in my office built the cluster ...
4
votes
1answer
308 views

Always On Availability Groups Network Configuration in AWS

I have set up a 3-node, multi-subnet Always On Availability group in AWS, which seems to be working well. However, each node only has a single network adaptor with 3 IP addresses assigned to it (1 ...
0
votes
1answer
434 views

Availability groups NIC best practices

I am planning to build a new AG setup in my QA environment with the following configuration. What I want to know is, can I have 2 heartbeat networks between the nodes for redundancy also, how many NIC'...