Questions tagged [tcpip]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
46 views

Connect to remote sql server is possible only by ipaddress\sqlinstance,portnumber?

I've configured a remote Sql server on host machine. I have performed the follwing steps : Under Remote Server Connections, check the box against "Allow remote connections to this server". ...
0
votes
0answers
13 views

SQL Server Agent on Linux Failover Cluster

We have set up FCI on Linux-SQL server, Everything is working except SQL server agent. Agent is Enable and running but Job are not executing. And Agent also getting stopped very often. Below are some ...
1
vote
2answers
314 views

How to connect to a local SQL Server instance by IP Address in SQL Server Management Studio? [duplicate]

I'm writing some test code that is required to connect to a local SQL Server instance (SQL Server 2017 - Developer Edition) by IP address. I have the SQL Server instance up and running on my machine, ...
0
votes
0answers
47 views

Alter table executes despite Lost connection to Mysql server

mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL) InnoDB engine I executed 'ALTER table ... drop column' on a mysql table. Despite the client losing connection to the server, I ...
0
votes
1answer
28 views

Database system checksumming to prevent network corruption not caught by TCP checksumming

Since TCP checksumming is not sufficient to detect/prevent all corruption, do modern database systems (e.g. SQL Server, MariaDB / MySQL, Oracle, etc.) use any additional checksumming of network ...
2
votes
1answer
260 views

Uniquely Append to Array on Conflict PostgreSQL

I've got two columns in PostgreSQL, hostname and ip. Hostname is the primary key and ip is an array of IPs. I want to be able to insert IPs for a give hostname, on conflict I want to append to the ...
1
vote
1answer
232 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 ...
-3
votes
1answer
84 views

Transfer Mysql table data to client Server via TCP/IP by using Trigger [closed]

i Have Database on MySQL Server. I have one Table so called "log" in Database. Data has been insert in Database table automatic. I would like to transfer table via TCP/IP to the another Software. ...
1
vote
1answer
319 views

What is Accepted NTLM SPNs

In SQL Server Configuration Manager on the Advanced tab in TCP/IP Protocol properties box there is an option Accepted NTLM SPNs. What is the use of that option and how it can be used?
0
votes
1answer
41 views

How to find out unused port on Linux server

We are trying to use port 5444 for our new PostgreSQL instance and we are not sure whether 5444 is used or unused. Could you please help us to find the answers to the below questions. We want to ...
4
votes
1answer
146 views

SQL Server Ignoring Instance name when using port number of different instance

I saw a strange case recently and still clueless on what should be the reasoning behind it. On one of my development server, two SQL server instances are running - one is default and other one is UAT ...
0
votes
2answers
868 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 ...
0
votes
2answers
91 views

How to connect an MSSQL database engine to a local network

I need to let my public IP connect to a database that is located within the same local network. Ex: MY public IP is: 190.222.222.222 The local IP of that PC is: 1.1.1.4 And this server already has an ...
1
vote
0answers
42 views

sql server connectivity broke down to server after its IP address has moved to a subnet. How to restore its connectivity?

I a server called Vermont on a different domain, with a trust relationship. I can ping the server there. But when I try to connect to it, from my SSMS I get the following error: I used to connect ...
7
votes
2answers
3k views

EventLog: Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use

This isn't a duplicate; my scenario is different from others I've found: MSSQLSERVER service does *not* start, port 1433 in use https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/10/05/tcp-port-is-...
1
vote
1answer
539 views

Mirroring issue with mirror server

I am running two Windows Servers 2012 R2 with SQL Server 2014 Standard Edition. I have strange issue on mirroring. I configured mirroring on for 15 databases, no Witness server. The Principal server ...
0
votes
1answer
1k 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 ...
1
vote
1answer
517 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
910 views

in what situations the dynamic port number in sql server is used?

I have the following script to find out what is the Static and dynamic port numbers: --=============================== -- sys.dm_exec_connections --=============================== SELECT [user]=...
1
vote
1answer
3k views

Binding specific ips with Mongodb

I am using Mongodb 3.6.3 on Centos 7. I am running the below command: sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all --logpath /var/log/mongodb/mongod.log --fork and everything ...
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 ...
6
votes
1answer
8k views

How to disable Postgres from listening on IPv6?

I am trying to disable Postgres from listening on IPv6 because of a bunch of strange trace files that are constantly being written to syslog. I'd prefer not to disable IPv6 in the OS itself, so ...
2
votes
1answer
17k views

mysql workbench failed to connect at localhost:3306 with user root ssl connection error: ssl is required but the server doesn't support it [closed]

Not sure what the answers are, but I will say that I have not found the answers on how to make this work again. The keyword support makes me think that a payment is required for this feature, but I'm ...
0
votes
1answer
1k views

Linked Server - Double Hop - Kerberos - TCP

I am having trouble with a Linked Server. I would typically not use a linked server, but legacy issues are forcing my hand. I am attempting to set up a linked server between two new production SQL ...
1
vote
1answer
337 views

AWS ORACLE Linux 7.4 - Connection issue

I tried to install oracle 12c in Oracle Linux 7.4 instance upon AWS ORACLE Linux 64 EC2 instance, I could make the installation and connect to the database from the ec2 server without any issue ...
0
votes
1answer
1k 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
0answers
306 views

Error 10054 encountered exporting localhost SQL Server to .bacpac

I am trying to export a localhost SQL Server database to a .bacpac file, and am encountering error 10054: "A transport-level error has occurred when receiving results from the server... An ...
1
vote
0answers
4k views

SQL Server Management Studio times out connecting to a remote SQL Server engine

I've done this at least a hundred times. Install SQL Server on a VPS Install it as the default instance Only install the engine, not SSMS Install Express edition Go to SQL Server Configuration ...
0
votes
0answers
235 views

How to enable the NoDelay parameter for SQL Server?

We have a recommendation from performance audit to "enable the "NoDelay" parameter on our database". I searched through Microsoft documentation and found that this parameter is configurable with SQL ...
0
votes
1answer
118 views

How do I write IPv4 slash notation in IPV6 [closed]

I have the following IPv4 address and mash in my Postgres hba.conf file: 192.168.0.0/24 Which works great when connecting my other Mac perfectly as long as I connect to the PostgreSQL database ...
4
votes
2answers
10k views

SQL Server Named Instance is not listening on Port 1434

We just installed SQL Server 2016 on a Windows 2016 server. I am having issues connecting to the Named Instance of that server. I have noticed that the server isn't listening on port 1434 either. ...
5
votes
1answer
3k views

Using TCP keepalive for terminating orphan postgres queries not working

Problem: A user of some application executes a report which involves a heavy sql query. After some minutes, the user then quits the application (or even worse, the app crashes, or the connection to ...
1
vote
2answers
1k views

Is there any SQL Database that will use UDP replication?

I have to find a database that will ensure the UDP replication intercontinental. Do you know if there is any SQL database that will support UDP replication? If not, can I use MySQL replication (TCP/...
1
vote
2answers
5k views

How do I get HeidiSQL to connect to Postgres databases for the first time?

With two different Linux servers I have installed Postgres on them using no standard configurations. They are in different networks off-site. The Postgres service is running (as I checked by running ...
3
votes
1answer
1k views

High number of undistributed commands after a “An existing connection was forcibly closed by the remote host” event

For the lasts days I'm getting a high undistributed commands value in the replication monitor. Restarting the Server Agent solve the problem (momentarily) but after few hours starts again. Even when ...
1
vote
1answer
1k views

Setup SQL Server SSL client certificate

I have created a certificate authority on my Linux server using OpenSSL. I have added that certificate authority to the Windows Trusted Root Certificate Authorities, which it now recognises. What do ...
2
votes
1answer
1k views

How can I connect to SQL Server from All IPs?

I have problem with access to SQL server with TCP/IP. I would like to SQL instance accept client from all network adapter that machine has. I go to configuration manager console and enable TCP/IP, ...
0
votes
1answer
621 views

Monitor SQL TCP traffic on the client

I have a Windows 7 client that has a data driven application that connects to our SQL Server 2008 R2. How can I view all the traffic between this software and the DB? I would mainly like to see ...
1
vote
2answers
555 views

SQL Replication across the internet give named pipe error

We've had a db replication working between two servers across the internet. Server A is sitting on our server network (Windows Server 2008 + SQL Server 2008 R2) Server B is sitting on a different ...
3
votes
1answer
17k views

How to configure SQL Server Port on multiple instances?

I have a server called SQLDWDEV01, with 2 instances: default and UAT. To the default instance that uses port 1433, everything works fine. However, the UAT instace, which I configured according to ...
4
votes
1answer
3k views

psql breaks if I specify host localhost

I am aware that this or similar has been asked in other places. None of the other answers have worked for me. Machine is a Macbook Pro 2014 / OS X Yosemite 10.10 with Postgres 9.3.5 installed via ...
1
vote
0answers
1k views

What happens when a mysql connection gets lost?

I hope this is a question for the dba board. Otherwise blame me and i'll switch to unix. imagine the following situation: you have a Mysql server S and two clients A and B. Both clients connect to S ...
2
votes
1answer
5k views

JDBC connection error for SQL Server Database

I have a SQL server names as MS8AT09\AT09. I am able to login to the server through Microsoft SQL server Management studio. While trying to login to same server through JDBC I am facing the error as ...
3
votes
2answers
3k views

Multiple SELECT vs single SELECT over TCIP

My question is a performance one: I need to select roughly 400+ rows, i know their ids. currently i loop in code and fire off multiple queries over tcp/ip - because its easy: ... select [columns] ...
9
votes
6answers
50k views

A transport-level error has occurred when sending the request to the server

In our Vb.net application(userd within a local network connection inside a office), which is used from long time now some of the users get the errors only sometimes a day A transport-level error ...
3
votes
1answer
6k views

Dropped Database Connections in SQL Server 2008R2

We are having an annoying intermittent problem where database connections from our client application on a variety of stations will get dropped. We have applications that use ODBC, Borland Database ...
7
votes
4answers
37k views

Changing IP address of SQL Server 2008 R2

I would like to know if there are any dangers or relevant precautions before changing the IP address of a SQL Server 2008 R2 box. We have built a virtual PC with Windows Server 2008 R2 and SQL Server ...
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 ...
0
votes
1answer
1k views

TCP sockets bottleneck with InnoDB/Debian?

We have a big mysql performance issue on a production environment with 18 "front" servers sending mysql queries to a unique mysql server. We are using Redis on each front server for a number of things,...
6
votes
2answers
9k views

Howto disable Postgres listening on TCP?

Simply to avoid many problems in the first place I do not want my postgres server program to accept/listen to anything from any network (i.e. TCP/IP 4/6) connections. My setup is a Postgres 9.1 on an ...