question

HtetLin avatar image
0 Votes"
HtetLin asked ErlandSommarskog commented

Not listening SQL Server Port 1433

I already installed MS SQL server Standard Version in my Window Server 2016 , After that can not connected from outside.
Already set up the setting in Server Configuration . But from remote port 1433 can't listening . It can open in my server but outside can't connected . Inside the Server firwall and antiviruse already turn off. I have checked , SQL Server services , TCP/IP port configuration , everything is ok . But can't connected from outslide.Please help me to advice. Thanks

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Check in SQL Server Configuration Manager => Tab Network if TCP/YP protocol is enabled.

Also lookup the SQL Server ErrorLog, at the beginning in the start sequence you should find an entry like "Server is listening on [ip-address <ipv4> 1433]"

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HtetLin avatar image
0 Votes"
HtetLin answered

Thank you for your Answer, TCP/IP protocol is already enabled. Still can not . Thanks .

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ben-Miller-DBAduck avatar image
0 Votes"
Ben-Miller-DBAduck answered ErlandSommarskog commented

Also make sure that this setting has 1 as the run value.

 sp_configure 'remote access'
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ben, that option has no relevance here. This option relates to the very old feature remote servers (predated linked servers) which I think is defunkt by now.

See also Books Online which calls this option obscure: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver15.

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @HtetLin-7338,
Please use the following commands in cmd of remote client to verify basic connectivity over IP address:

 ping –a <SQL Server machine> or ping –a <SQL Server IP address>
 telnet <your_target_machine> <TCP_Port>

And please make sure the SQL Server allowed to connection remotely as Ben-Miller-DBAduck mentioned. And you can check the SQL Server whether is listening on port 1433 in the SQL Server Configuration Manager ->SQL Server Network Configuration->Protocols for instance->TCP/IP properties->IP addresses tab.
In addition, here is an article which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.