Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tcpip]

56 questions
24
votes
1 answer

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 number (say 1971) does that signify that you have a…
Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
15
votes
4 answers

EventLog: Server TCP provider failed to listen on [ 'any' 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…
InteXX
  • 559
  • 2
  • 7
  • 17
10
votes
8 answers

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 has occurred when sending the request to the server.…
IT researcher
  • 3,168
  • 15
  • 59
  • 82
9
votes
1 answer

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 after seeing mention of the trace messages, and…
rhelfand
  • 171
  • 1
  • 1
  • 6
7
votes
4 answers

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 2008 R2. The purpose of this machine is run a job…
Paul
  • 1,453
  • 6
  • 19
  • 38
7
votes
2 answers

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 Ubuntu 12.04 box and I thought tweeking…
humanityANDpeace
  • 383
  • 1
  • 3
  • 10
7
votes
2 answers

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 database: the server reports FATAL: no pg_hba.conf entry…
Sean Allred
  • 207
  • 1
  • 4
  • 10
6
votes
2 answers

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. Normally we would see it in log as: Server is…
kaitlyn
  • 593
  • 2
  • 7
  • 15
6
votes
1 answer

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 the database server is lost). The query however…
Federico Cristina
  • 173
  • 1
  • 6
5
votes
1 answer

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 the pictures below, I cannot connect from my local…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
5
votes
2 answers

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 Homebrew. I can only connect to my local postgres…
iftheshoefritz
  • 161
  • 1
  • 7
4
votes
1 answer

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 array with the data I'm trying to insert and the…
Craslam
  • 43
  • 1
  • 3
4
votes
1 answer

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 instance. Recently we made the change to the…
Learning_DBAdmin
  • 3,924
  • 19
  • 39
3
votes
1 answer

What happens on the server when a MySQL client connection is lost?

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 permissions and inserts a row into the table. Now B tries…
rralf
  • 139
  • 2
3
votes
2 answers

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] where id = 1544; select [columns] where id =…
CrazyTim
  • 133
  • 1
  • 5
1
2 3 4