Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQLExpress TCP/IP Connection

Int3g3r's profile image Int3g3r posted 1 month 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

Int3g3r's profile image Int3g3r posted 1 month ago Permalink

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

Int3g3r's profile image Int3g3r posted 1 month 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
vikramjkn's profile image vikramjkn posted 1 month ago Permalink

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

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.