Questions tagged [tcpip]
The tcpip tag has no usage guidance.
55
questions
0
votes
0
answers
13
views
utl_tcp fetch exact length of response
I am using utl_tcp to connect to an external service and return some data. All is fine until I get to this line:
utl_tcp.get_text(c, 100)
The issue with this is the call waits for the timeout I have ...
- 115
0
votes
1
answer
52
views
SQL Server listening port not showing in errorlog
Does any one know why the port my SQL Server is listening on would not be recorded in my errorlog? TCP/IP is enabled and default listening port 1433 configured.
I have this issue on two servers:
one ...
- 295
0
votes
0
answers
193
views
Unable to connect to local DB2 instance
I have installed an Enterprise version of DB2 on my local Windows 11 pro laptop for some development tasks.
Installation proceeded without errors but, it seems I cannot connect using TCP. If I try to ...
- 133
-1
votes
1
answer
528
views
Proper way to setup oracle database for TCPS SSL in local machine
I am using oracle database 12c and would like to setup TCP SSL connection to be able to connect using the same machine where the database is hosted. So, connection would be from database machine to ...
0
votes
2
answers
285
views
Network connect to a local IP address from a static global IP address?
Is there a possible way to connect to a local SQL server on a static global IP?
Let me elaborate.
Assume that there is a server with a static global IP of 12.345.678.90 which refers to a certain ...
- 23
0
votes
1
answer
545
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 ...
- 3
-1
votes
1
answer
516
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".
...
- 71
3
votes
2
answers
18k
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, ...
- 34.2k
0
votes
1
answer
34
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 ...
- 121
3
votes
1
answer
2k
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 ...
- 33
1
vote
1
answer
721
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,243
-3
votes
1
answer
224
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. ...
2
votes
1
answer
2k
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?
- 21
0
votes
1
answer
166
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 ...
- 1
4
votes
1
answer
604
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 ...
- 3,864
0
votes
2
answers
2k
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 ...
- 103
0
votes
2
answers
691
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
0
answers
95
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 ...
- 15.8k
15
votes
3
answers
9k
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-...
- 549
1
vote
1
answer
1k
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
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 ...
- 1,021
1
vote
1
answer
765
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 ...
- 2,120
1
vote
1
answer
1k
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]=...
- 15.8k
1
vote
1
answer
4k
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 ...
- 235
2
votes
0
answers
88
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 ...
8
votes
1
answer
12k
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 ...
- 151
0
votes
1
answer
2k
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
1
answer
407
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 ...
- 13
0
votes
1
answer
2k
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 ...
- 1,939
1
vote
0
answers
5k
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 ...
- 1,407
0
votes
0
answers
319
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 ...
- 313
0
votes
1
answer
145
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 ...
- 101
4
votes
2
answers
15k
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. ...
- 563
6
votes
1
answer
5k
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
2
answers
2k
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/...
- 13
1
vote
2
answers
7k
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 ...
- 13
3
votes
1
answer
2k
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 ...
- 159
1
vote
1
answer
2k
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 ...
- 113
2
votes
1
answer
2k
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, ...
- 131
0
votes
1
answer
891
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 ...
- 285
1
vote
2
answers
770
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 ...
- 443
5
votes
1
answer
24k
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 ...
- 15.8k
5
votes
1
answer
4k
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 ...
- 161
3
votes
1
answer
2k
views
What happens on the server when a MySQL client connection is lost? [closed]
Imagine the following situation:
You have a MySQL server S and two clients, A and B.
Both clients connect to S (e.g. using the CLI).
A starts a transaction and then locks a table with WRITE ...
- 139
2
votes
1
answer
6k
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
2
answers
4k
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] ...
- 133
10
votes
8
answers
65k
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,131
3
votes
1
answer
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 ...
- 255
7
votes
4
answers
39k
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,453
1
vote
1
answer
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,913