Questions tagged [network]

The tag has no usage guidance.

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
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
0answers
167 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 ...
2
votes
0answers
665 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 ...
2
votes
1answer
721 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 ...
2
votes
0answers
59 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
1answer
2k 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
0answers
259 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 ...
2
votes
0answers
460 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 ...
2
votes
2answers
203 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 ...
1
vote
1answer
30 views

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

My MySQL (actually 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 ...
1
vote
0answers
335 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 ...
1
vote
1answer
56 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 ...
1
vote
0answers
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
0answers
200 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
0answers
139 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 ...
1
vote
0answers
90 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
vote
0answers
31 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
0answers
26 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 ...
0
votes
1answer
206 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 ...
0
votes
0answers
19 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 ...
0
votes
0answers
10 views

How to apply many UPDATE statements in one network call

Can we apply many UPDATE statements in a single network call? Figure many UPDATE requests on a JSONB field of one record. I would like to update many places in the JSONB field. All updates apply on ...
0
votes
1answer
159 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 ...
0
votes
0answers
124 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 ...
0
votes
1answer
209 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
0answers
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 ...
0
votes
0answers
520 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, ...
0
votes
0answers
269 views

Startup Oracle Database with an NFS mount on the control file

I currently have an Oracle Database which works just fine on 1 server. I want to share the folder which contains its' control file to another server via an NFS mount. However when mounted I get ...
-1
votes
1answer
135 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 ...