Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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
ComputeDatabase
Tags
Amazon EC2Microsoft SQL Server
Language
English

asked 2 years ago511 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.

EXPERT

answered 2 years ago

EXPERT

reviewed 2 years ago

  • tnk
    2 years 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.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content