Connect To SQL Server On AWS Windows Instance

Question

Hi,
We have one Windows instance with AWS cloud and our SQL Server is installed on this windows instance.
We want to connect to the SQL Server on AWS Windows instance from our work computers but unable to do so.
When trying to connect to the SQL Server - we get SQL Server Error 53.

Port 1433 is opened for our public IP address under Windows Firewall on Windows instance, and an inbound rule is also added for MSSQL (1433) with our public IP under AWS Console security group.

Could you please help.
Thank you.

Answer

Remote access may be denied on the SQL server side.  
You can change the SQL server settings by following the instructions in the following document.  
https://learn.microsoft.com/ja-jp/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver16

Otherwise, select the protocol for the instance in "SQL Server Network Configuration" and make sure "TCP/IP" is "Enabled" and the "SQL Server Browser" service is running.

Answer

Thank you for your response.
SQL remote access and TCP/IP both were already enabled and SQL Server Browser service is also running!

I tried allowing all traffic through windows firewall and on AWS instance security group inbound rules.
But it is still not connecting...!! :( :(

Connect To SQL Server On AWS Windows Instance

相关内容