Questions tagged [network]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
29 views

MS Access and multiple users

I'm looking for some help regarding Microsoft Access and database design. I have been developing a database application on Microsoft Access for use in my organisation. I work in a hospital and we have ...
user avatar
  • 3
0 votes
1 answer
33 views

Is it considered safe to add the public IP of a host to listen_adresses and the pg_hba file?

I have kind of a naive question, but for the moment it's the only way I found to access a local (I mean, located on the host machine) PostgreSQL database from a docker container, so I'm wondering: is ...
user avatar
  • 216
0 votes
0 answers
38 views

Is it possible to disable DoneInProc tokens in MSSQL Server [duplicate]

I have a PLC library that isn't able to parse the return packet from MSSQL when it includes DoneInProc tokens before the ColumnMetaData and Row data. I've contacted the author of the library, but he ...
user avatar
  • 101
1 vote
1 answer
146 views

Does SQL Server require NetBIOS for Named Pipes?

I'm not all that familiar with networking or protocols and couldn't find a similar question here or elsewhere. One of my security people is asking whether SQL Server requires NetBIOS for Named Pipes. ...
user avatar
0 votes
1 answer
99 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,...
user avatar
0 votes
1 answer
231 views

Why Federatedx Engine is very slow in MariaDB 10.6 and have to read all the table to get only first 10 rows? [duplicate]

I am trying to get 10 rows from one MariaDB to another MariaDB. However, It takes one and half minute. I have created the table with federated engine pointing to remote MariaDB. Including all the ...
user avatar
0 votes
0 answers
67 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 ...
user avatar
  • 109
1 vote
1 answer
325 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 ...
user avatar
0 votes
1 answer
30 views

VM'd a SQL server, having trouble with external HDDs

First I am not a SQL DB. I inherited an old system and am trying to keep the wheels from falling off. We have an MS SQL 2000 server (running server Win Server 2000) that we performed a P2V migration ...
user avatar
  • 75
0 votes
1 answer
169 views

IP Addresses tab is not showing a specific IP Address

I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network interface. I Added a USB MODEM (4G) to the server and went to the IP Addresses tab in network ...
user avatar
0 votes
2 answers
1k views

The listener supports no services - 2 databases on oracle linux 7

I'm running two 12c R2 databases on linux oracle 7.9 I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
user avatar
0 votes
2 answers
84 views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

(more details/replicate from: https://superuser.com/questions/1612260) Dear all, I'm a total newbie in connecting 2 PCs and making them use the same SQL server DB from one computer ... so please ...
user avatar
  • 1
2 votes
4 answers
210 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 ...
user avatar
  • 935
0 votes
1 answer
506 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 ...
user avatar
0 votes
0 answers
38 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 ...
user avatar
  • 47
2 votes
0 answers
907 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 ...
user avatar
0 votes
1 answer
55 views

Web server accessing the database server in Always on availability group

We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
user avatar
  • 1,007
0 votes
1 answer
252 views

Making an Oracle XE instance network wide available

Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
user avatar
13 votes
3 answers
3k views

Disconnect from network without stopping the query

I have an opposite problem to Does disconnecting the network stop a query?. I would like to launch a query and disconnect without waiting for results but I don't want the query to stop. Is it possible?...
user avatar
0 votes
1 answer
560 views

How to use BCP Utility queryout in a network path with crededential (login required) for SQL Server

I'm having a hard time figuring out on how can I export my selected table in a network path that requires login credentials. 'bcp "select ''StudentName'' UNION ALL SELECT StudentName AS ...
user avatar
0 votes
1 answer
1k views

What is the max network latency between synchronous-commit AlwaysOn Availability Groups [closed]

Is there a maximum supported network latency (ms) between two synchronous AlwaysOn replica? I need to give this information to network administrators for configuring the link between the two nodes of ...
user avatar
  • 97
0 votes
1 answer
45 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
user avatar
  • 2,337
0 votes
2 answers
247 views

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured. Consider that the leader node crashes. Two ...
user avatar
0 votes
1 answer
354 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 ...
user avatar
  • 183
3 votes
0 answers
1k 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 ...
user avatar
  • 84
1 vote
1 answer
433 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 ...
user avatar
  • 1,163
0 votes
0 answers
193 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 ...
user avatar
-1 votes
1 answer
53 views

Connecting database from another network [closed]

We have a database in our server at work, and we can connect the database if we are connected to same network with server. I want to connect from my home. How can I do this? I have tried couple of ...
user avatar
2 votes
1 answer
90 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 ...
user avatar
0 votes
2 answers
687 views

ASM - How the asm search the disks and where is this parameter from?

I'm a begginer in Oracle ASM and when I will create a diskgroup the ASM shows me this parameter: Where is this parameter from? I don't remember set any parameter with this name. I know that usually ...
user avatar
  • 506
0 votes
1 answer
351 views

Oracle - Why create several service_name in service_names parameter?

SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener ...
user avatar
  • 506
2 votes
1 answer
426 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 ...
user avatar
0 votes
1 answer
397 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 ...
user avatar
3 votes
0 answers
216 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 ...
user avatar
  • 31
0 votes
2 answers
1k views

How to connect to sql server with dynamic IP Address

I have installed sql server express edition 2014 on my machine. And I am connecting to it with CRM using my local machine's IP address. The problem here is my IP address allocated to my machine is ...
user avatar
0 votes
0 answers
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 ...
user avatar
1 vote
1 answer
66 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....
user avatar
  • 402
6 votes
2 answers
2k views

Are CNAME aliases for connection strings a good idea?

To be very flexible and move database to different servers more easily, we came up with the idea of using an alias per database. So by simply changing a DNS entry, we can route all queries to a ...
user avatar
-1 votes
1 answer
169 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 ...
user avatar
0 votes
1 answer
29 views

Domain Controller on Multi Subnet Always on Availability Group

This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
user avatar
  • 1,007
1 vote
1 answer
933 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 ...
user avatar
  • 1,007
1 vote
1 answer
78 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 ...
user avatar
  • 1,450
3 votes
1 answer
4k 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.
user avatar
  • 55.7k
1 vote
1 answer
2k 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 ...
user avatar
  • 1,007
1 vote
1 answer
59 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 ...
user avatar
  • 11
2 votes
1 answer
344 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
  • 1,007
0 votes
1 answer
985 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 ...
user avatar
  • 2,006
1 vote
1 answer
631 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 ...
user avatar
  • 2,006
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 ...
user avatar