I want to connect from an external host to my database.
I open the port on the firewall and the TCP/IP are active on my 2008 R2 database istance.
My database is SERVERNAME\DOMAIN
From eternal i try to connect with SERVERIP\DOMAIN where SERVERIP is the external ip of my server. THe routing on firewall redirect the call from 1433 to server IPADDRESS
Why doesn't work?
I have on the same server another istance of 2005 SERVER SQL and if i try the connection by SERVERIP with no istance, the connection are fully functional with this database. When i try adding the istnace name to connect to other db , always 10060 error
Wher's the problem?
************************************************ the world is strange but people are crazy
Check if remote connections are enabled for the server. You can do it from SQL Server Management studio - right click on server name in object explorer, select Properties and look under Connections.