Click here to Skip to main content
15,178,918 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have configured my SQL Server for remote connection.
I can connect my SQL Server through LAN using my IP address.
But when i try to connect through internet it raise error "A network-related or instance-specific error occurred while establishing connection. The server was not found or was not accessible. Verify that instance name is correct and that SQL Server is configured to allow remote connections."

Please note that my SQL Server is accessible through LAN.
I have set my port opened in Router Port Forwarding Setting.(Port is accessible through internet)

What else should i do for access my SQL Server through internet?

Thanks
Posted
Comments
Mehdi Gholam 27-Jun-15 2:56am
   
Which ports are forwarded?
Dhanesh Nambiyar D'yen 27-Jun-15 3:11am
   
PORT 1433 which is set For IP All in SQL Servers TCP/IP Properties
Mehdi Gholam 27-Jun-15 5:12am
   
Are your clients connecting with TCP or named pipe?
Dhanesh Nambiyar D'yen 29-Jun-15 4:55am
   
my client connecting with TCP
Dhanesh Nambiyar D'yen 29-Jun-15 5:07am
   
for now i am trying to connect my SQL Server from same computer using public IP address, but getting same error message
David A. Gray 16-Jul-15 20:24pm
   
Security best practices would have the firewall drop incoming packets on port 1443, unless the source IP address is on the local network. While there are legitimate cases for connecting over TCP/IP from outside, connections from the outside world can be made a lot more safe and secure by making HTTP requests or connecting to a Web service that talks to the SQL server.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900