Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Flaterik
Starting Member
26 Posts |
Posted - 2012-01-21 : 08:03:20
|
Hi people i have a problemI 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\DOMAINFrom 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 IPADDRESSWhy 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 errorWher's the problem?************************************************the world is strange but people are crazy |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-21 : 09:01:21
|
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. |
|
|
biswajitdas
Starting Member
44 Posts |
|
|
|
|