Share via

Not listening SQL Server Port 1433

Htet Lin 46 Reputation points
2020-12-17T10:26:00.413+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,031 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,361 Reputation points
    2020-12-17T11:52:11.51+00:00

    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]"

    1 person found this answer helpful.
    0 comments
  2. Htet Lin 46 Reputation points
    2020-12-18T00:55:44.997+00:00

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

    0 comments
  3. Ben Miller (DBAduck) 951 Reputation points
    2020-12-18T03:22:14.153+00:00

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

    sp_configure 'remote access'
  4. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2020-12-18T06:22:59.98+00:00

    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.

    0 comments