SQLExpress TCP/IP Connection

3 posts
Int3g3r's profile image Int3g3r posted 2 years ago in Creating a connection Permalink

Hello

How can I establish a TCP/IP connection to a MS SQL 2016 Express Server? What needs to be set on the server?

The connection via MSSQL works. Firewall is disabled. I can connect with (named pipe)/SQLOLEDB.

I have already tested the following:

Regards Int3g3r

Description Description

3 posts
Int3g3r's profile image Int3g3r posted 2 years ago Permalink

I tested already. Search -> "Using HeidiSQL with SQLexpress" without success.

3 posts
Int3g3r's profile image Int3g3r posted 2 years ago Permalink

I have found the solution. In SQL Server Configuration Manager it is necessary to set the port. The TCP/IP port is not automatically set to 1433.

SQL Server Configuration Manager -> SQL Server Network Conf. -> Protocols for "instance" -> TCP/IP

  • Tab Protocol, Enabled = YES
  • Tab IP Addresses, IPAll TCP Port = 1433
1 posts
vikramjkn's profile image vikramjkn posted 2 years ago Permalink

Right we need to define port 1433 for sql server always even when you are connecting to Azure or Amazon RDS

4 posts
jtome's profile image jtome posted 1 year ago Permalink

Thanks Ing3g3r for posting your solution. I've been trying to solve this off an on for months and finally stumbled on this post.

I have found the solution. In SQL Server Configuration Manager it is necessary to set the port. The TCP/IP port is not automatically set to 1433.

SQL Server Configuration Manager -> SQL Server Network Conf. -> Protocols for "instance" -> TCP/IP

  • Tab Protocol, Enabled = YES
  • Tab IP Addresses, IPAll TCP Port = 1433

Please login to leave a reply, or register at first.