Verify that the instance name is correct and that SQL Server is configured to allow remote connections. It is also safe to run the script multiple times with the same parameters. The script includes many parameters, but most of them have default values defined to make it easier for first-time users. Successful connection example: Failed connection example: Make sure your RDS instance is Public and Inbound rules allows your IP. You can deploy SQL Server by running the included script and passing the required parameters. The server was not found or was not accessible. Open your terminal (MacOS), and type the following: nc -zv awsrdsendpoint portnumber. Often the first connection attempt fails then the second one succeeds:Ī network-related or instance-specific error occurred while establishing a connection to SQL Server. It is also experienced on two RDS instances.Īs I say, it is intermittent (but frequent) so it is not a connection string issue or a firewall issue. NET application or from MS SQL Server Enterprise Studio. The issue is experienced when connecting from a. It is also experienced from Windows EC2 connecting to the DB. The issue is experienced from multiple sites/networks in two countries. I think it is slightly improved when using the RDS IP address as opposed to the host name. I'm having intermittent issues connecting to RDS SQL Server Express.
0 kommentar(er)
