Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server connection error 10054

Status
Not open for further replies.

IlyaRabyy

Programmer
Nov 9, 2010
571
US
Colleagues,
we're trying to set up remote connection between a Win Server 2016 (has SQL Server Native Client 11.0 X64) with SQL Server 2012 (on another box, also Win Server 2016).
Connection format: telnet <server name or ip> <port number>.
Got the following error message:
2020_08_13_SQL2012_ConnectionErr_10054_lb6qxr.jpg

I found somewhat related post in but still unclear on what to do.

Please advise.
TIA!

Regards,

Ilya
 
Well, it means technically the connection can be made, but for some reason the server closes the connection. For example because the IP address is blocked. I don't know how many reasons there could be, group policies, account blocked, anything. I think only the server admin and SQL server dba could find out more.

Bye, Olaf.

Olaf Doschke Software Engineering
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top