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]"
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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]"
Thank you for your Answer, TCP/IP protocol is already enabled. Still can not . Thanks .
Also make sure that this setting has 1 as the run value.
sp_configure 'remote access'
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.