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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error 10060 connecting from remote host

Author  Topic 

Flaterik
Starting Member

26 Posts

Posted - 2012-01-21 : 08:03:20
Hi people i have a problem

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

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.
Go to Top of Page

biswajitdas
Starting Member

44 Posts

Posted - 2012-01-22 : 18:04:40
1) is the new SQL server was set to Windows Authentication Only?

The below link can help you .
http://msdn.microsoft.com/en-us/library/bb326282.aspx

Sr Sql server DBA/Artitech
Go to Top of Page
   

- Advertisement -