2

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?

marc_s
9,0626 gold badges46 silver badges52 bronze badges
asked Oct 30, 2015 at 16:39

2 Answers 2

0

I solved. I added a security group on the VPC Security groups on the EC2 console: enter image description here With this rule ( actually too broad, but just to confirm where the issue is ) enter image description here

by modifying the db instance ad add this security group, it accept incoming connections from remote.

answered Oct 31, 2015 at 6:34
0

SQL Server Express does not enable a TCP/IP listener by default. You must enable it using SQL Server Configuration Manager to allow remote connections.

answered Oct 31, 2015 at 1:02
1
  • Yeah I know, but this instance is on AWS so I cant have so much control over it Commented Oct 31, 2015 at 6:24

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.