Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
2k views

Network issues with sql server

There are two servers on co-location. First is Windows Server Standard 2008 R2 SP1. Second is Windows Server 2012 + Sql Server Standard 2012 SP1. First server has a task with a report against tables ...
3
votes
0answers
153 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
2answers
6k views

Connection to localhost dramatically slower than to network server

I have an Excel VBA application that connects to a SQL Server 2008 R2 database through ADODB. When I'm on the network at work, the connection is almost instantaneous. When I am at home working with ...
2
votes
1answer
291 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 ...
2
votes
1answer
255 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 ...
2
votes
1answer
9k views

Can you put a SQL DB on a NAS? [closed]

Can you put a SQL DB on a NAS drive? For example can I put the PostgreSQL DB "files" on a Sinology NAS or am I better to leave everything on a "real" PC? (like, say, a regular PC server running Linux) ...
2
votes
2answers
4k views

SQL Server Express 2014: Network Access

I have SQL Server Express running on one (virtual) machine running Windows 8.1, but I cannot connect to it from another. I have followed the instructions on https://msdn.microsoft.com/en-us/library/...
2
votes
4answers
187 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 ...
2
votes
1answer
317 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 ...
2
votes
1answer
308 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 ...
2
votes
1answer
662 views

SQL Native Client and network disconnects

Does the SQL Native Client provide support for maintaining a persistent connection over the network at the driver level if there is a momentary network disconnect like a 999 error? Our applications ...
2
votes
1answer
57 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 ...
2
votes
1answer
5k views

Attaching / creating database on network drive - Access is denied

I have two computers, computer A is with SQL Server but has no space left, the other is computer B which has free space. I'd like to create a new database on computer B. This is what I've done so far:...
2
votes
1answer
2k views

Is there any impact to changing IP address of MySQL Server?

We are changing the network and the IP addresses will be changing. Will there be any impact to MySQL running on the server? I don't use the IP address to reference the server. Instead I use the ...
2
votes
1answer
805 views

Fast local backup - Very slow backup via Network

Since last week, i'm having this problem. Backups are taking forever to be done if I make them via Network. If I backup the database to a local disk ( or N'nul' ) it's very fast. It's strange ...
2
votes
1answer
155 views

What methodology is being used to poll SQL instances when using sqlcmd with the -L switch?

I've discovered that issuing sqlcmd -L from the console of a SQL host in my network only reveals other instances on the same subnet. It used to reveal all instances on the network so I was wondering ...
2
votes
2answers
10k views

How to connect to Oracle 11g using “Navicat for Oracle”?

My Oracle 11g Enterprise Manager runs like this: I have taken the following screen-shot after my Oracle installation has been completed: I have the following Oracle-related services running: I am ...
2
votes
1answer
355 views

database connection time expired issue

I have a server machine and four client machine for database connectivity. I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
2
votes
1answer
705 views

PostgreSQL: Trouble accessing another server's Data via NFS

Background: I'm working on a 2-node High Availability PostgreSQL database cluster for my company. The system has a master/standby setup where the standby takes over the duties of the master when the ...
2
votes
0answers
559 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
699 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
829 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 ...
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
444 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
2answers
2k views

Can't use SQL Server database on a networkpath

I am working on a project for a very long time now. It's a .NET application which works with a SQL Server database (.mdf, LINQ to SQL). Now I am almost finished and wanted to run some tests. But ...
1
vote
1answer
539 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
1answer
7k views

How to grant access to IP range in Postgres?

I would like to configure my Postgres DB to be accessed by any IP 10.8.101.*. I know I have to create a rule in pg_hba.conf but I'm not sure what it should look like. My LAN IP is currently 10.8.101....
1
vote
2answers
3k views

SQL Server - login failure every day at same time with the service account

I have dozens of SQL Servers, on many different versions. Many of them have an error in the SQL Server error log EVERY DAY at just about 2 am. Login failed for user 'TheDomain\...
1
vote
1answer
1k views

How does disabling a network protocol affect SQL server performance

The SQL server 2000 process info monitor displays about 100 processes that use a mix of Named Pipes/TCP-IP and (integrated authenticated) users. I was wondering if: disabling Named pipes - or - TCP-...
1
vote
1answer
83 views

Disabling protocols using SQL Server Configuration Manager or ENDPOINTs

Besides SQL Server Configuration Manager, it's possible to disable access to specific SQL Server protocols by disabling the default ENDPOINTs, but what's the difference between the two options? Are ...
1
vote
1answer
246 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
vote
1answer
53 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....
1
vote
1answer
726 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
2answers
2k views

If shared memory, named pipes, TCP/IP network protocols are all enabled which has priority?

If you have all 3 protocols enabled in SQL Server 2016, which protocols are prioritized on the server instance? Couldn't find any specific documentation on this and don't really understand how it ...
1
vote
1answer
2k views

How to isolate that network is issue of bad query performance [closed]

I would like to know how to isolate SQL Server bad query performance is caused by NETWORK and not the SQL Server. Are there any specific tips and tricks in SSMS, wait types, or specific PerfMon ...
1
vote
1answer
57 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 ...
1
vote
1answer
1k 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
1answer
2k 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 ...
1
vote
2answers
210 views

MySQL Replication issues on server placed in different continents

I am running 2 cpanel servers with MySQL Replication set on them, one in france the other in US. Running a database hungary site. Replication was setup to load balance as well as for failover reason ...
1
vote
1answer
684 views

Access Linked Tables and Their Network Connections

I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A ...
1
vote
1answer
1k views

Possible reasons for slow BLOB updates in Oracle?

We have an application that transfers .bmp images as BLOBs to an Oracle table. One of the users of the app has complained that it is taking 2-3 seconds to transfer each image. Each image is ~1.2Mb. I'...
1
vote
1answer
251 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 ...
1
vote
2answers
134 views

How to link different databases? [closed]

We are a company doing surveys with different kind of questionnaires. There is a company in Mumbai (MySQL) specialized in Type 1 questionnaire and one in Peru (SQL-Server) specialized in Type 2. I ...
1
vote
1answer
3k views

How Should TCP/IP be configured to allow an external application access to SQL via the same port #?

My SQL Server instance is hosted on an internal network server (10.x.x.x address). It's a named instance currently using dynamic ports. An external application at a third-party hosting location ...
1
vote
1answer
1k views

High Network usage on SQL Server port [duplicate]

Possible Duplicate: Find out what queries are causing the biggest amount of network traffic We are getting over 90 Mbps from SQL Server to each web servers on port 1433. We are using connection ...
1
vote
1answer
2k views

MySQL Cluster over WAN: Best Architecture Options?

My company is looking at a multi-data-centre solution for high-availability, fun, and profit. We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
1
vote
0answers
225 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 ...