SQLExpress TCP/IP Connection

3 posts

Int3g3r posted 3 years ago in Creating a connection

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

3 posts

Int3g3r posted 3 years ago

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

3 posts

Int3g3r posted 3 years ago

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 posted 3 years ago

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

4 posts

jtome posted 2 years ago

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