Questions tagged [tcpip]

The tag has no usage guidance.

0
votes
2answers
95 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
69 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
36 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 ...
1
vote
1answer
190 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-...
0
votes
1answer
124 views

Can't connect to MS SQL Server via IP address anymore

I'm using a PLC connected to a laptop (over EthernetIP). The development software for programming the PLC has a built in settings page for connecting it to various database engines (MySQL, PostgreSQL, ...
1
vote
1answer
57 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
243 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
381 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
488 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]=...
0
votes
1answer
1k 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 ...
2
votes
0answers
52 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 ...
3
votes
1answer
3k 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 ...
1
vote
1answer
7k 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
469 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
202 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
674 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
167 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
2k 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
144 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
96 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
4k 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
2k 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
590 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
3k 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
716 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
917 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
459 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
438 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
414 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
10k 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 ...
3
votes
1answer
2k 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
857 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 ...
1
vote
1answer
4k 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 ...
1
vote
2answers
2k 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] ...
7
votes
5answers
37k 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 ...
6
votes
4answers
33k 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,...
4
votes
1answer
8k 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 ...
7
votes
2answers
39k views

Connecting to an external database with pgAdmin III

I'm trying to connect to an external database from pgAdmin III (which is installed on both machines). The client complains: Access to database denied The server doesn't grant access to the ...
23
votes
1answer
34k views

When is a Dynamic Port “dynamic”?

I was having a discussion today about Dynamic Ports with one of my co-workers and could use some help clarifying how they work. First question: If the IPALL TCP Dynmaic Ports setting is a specific ...
0
votes
1answer
723 views

Remote RESTORE of database through SSMS

How can I RESTORE a database through SQL Server Management Studio by connecting "remotely" to it? If I know the "IP address" of the target machine what else do I need to know? If the port number is ...