Remote connection to a specific SQl instance over the internet
Posted on 2008-06-19
I have a test Windows 2003 SP2 server with SQL2000 installed which is running fine.
I have just installed a new installation of SQL2005 on this box and am having problems connecting to it over the internet. (Instance called SQL2005). Mixed Mode Authentication enabled.
Windows Firewall is disabled.
Hardware firewall Ports open : TCP 1433 for SQL2000, TCP 1435 for SQL 2005, UDP 1434 for SQL2005 Browser service.
Surface Configuration manager has been run to allow Remote Connections.
SQL2005 Configuration Manager has TCPIP enabled, Listen All , TCP Dynamic port set to 1435 on external IP address only.
I am trying to connect to this server over the internet using SQL Server Management Studio on my PC but it fails every time.
I am using SQL Authentication to connect using TCPIP protocol.
I have tried entering the server's IP address in Server name and also servername\insytancname with no luck. I get a connection error message : 20476.
"(provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)"
Error Number: 10060
Any ideas anyone ?