I'm trying to remote connect a SQL Server Express instance that is running on AWS on a db.t2.micro. I'm getting the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The requested name is valid, but no data of the requested type was found.) (Microsoft SQL Server, Error: 11004)
I'm behind a proxy, but I should have route the address so the proxy is bypass for the IP of the SQL Server Express instance. What else can I try?
Best Answer
I solved. I added a security group on the VPC Security groups on the EC2 console:
With this rule ( actually too broad, but just to confirm where the issue is )
by modifying the db instance ad add this security group, it accept incoming connections from remote.