By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Hide Port 1433 from the connection

0

Good day. I have a question. I have an EC2 server with SQL Server, and everything works well. However, when I try to connect using Heidi, for example, I do it like this: server name/instance name, and it forcibly asks for port 1433. If I don't specify the port, it says it couldn't find the instance. Is there any way to avoid specifying the port? The port is already configured in the Network Manager.

Topics
DatabaseCompute
Tags
Microsoft SQL ServerAmazon EC2
Language
English
tnk
asked a month ago219 views
1 Answer
0

Hello.

The port number you specify when connecting is the listening port of SQL Server, so if you don't specify it, "Heidi SQL" will not be able to determine which port number to use to connect to SQL Server.

profile picture
EXPERT
Riku_Kobayashi
answered a month ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
  • tnk
    a month ago

    Thank you very much for the response. Is this a requirement from AWS? Previously, I was able to connect to a server at my workplace from home without specifying the port.

Relevant content